MikeWile

Reports with empty fields

Discussion created by MikeWile on Jan 3, 2017
Latest reply on Jan 4, 2017 by beverly

I have a report that lists employee hours in a particular date range. The report sorts by employee ID, then a field called BU, then by a product ID. What I'd like to see is only a total in the BU line if the BU field is empty and ignore the product ID items (but still have the hours calculated in the BU line). Is this possible?

 

What I see:

WhatIHave.png

What I'd like to see:

WhatIdLikeToSee.png

Outcomes