Skip to Content

Hiding Details with a Sum to Zero in group footer

I designed a report and then have sum of details on the group footer. I want to hide the details when the sum is zero of that particular group.

I created a report to calculate stock batches transactions i.e. the inbound and the outbound. So when a batch is fully issue out, it becomes zero. so on my report i need it not to appear when its now zero that is hiding the details and the total (sum and quantities).

roland-stock-report-to-support.png

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Aug 07, 2017 at 09:23 AM

    Hi Tendayi,

    Go to the Report Menu > Select 'Selection Formulas' > Group. Use this code:

    SUM({Summary Field}, {Group Field}) > 0

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 07, 2017 at 05:48 PM

    Thanks Abhilash. but the problems is to hide the group on the details when the Sum of my summary field is zero.

    Thank you.


    Add comment
    10|10000 characters needed characters exceeded

  • Aug 08, 2017 at 07:24 AM

    Hi Tendayi,

    That's what a Group Selection formula does. The formula I posted above should hide the entire group when the summary is zero.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded