Hiding Details with a Sum to Zero in group footer

[tchidawanyika]

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

[abhilash_kumar · Accepted solution]

Hi Tendayi,

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

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

-Abhilash

[abhilash_kumar]

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

[tchidawanyika]

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

Thank you.