1 2 3 Previous Next 30 Replies Latest reply on Jan 4, 2017 6:01 AM by beverly

    Reports with empty fields

    MikeWile

      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

        1 2 3 Previous Next