Skip to Content
0

Hiding Details with a Sum to Zero in group footer

Aug 07, 2017 at 07:59 AM

42

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Tendayi Chidawanyika Aug 07, 2017 at 05:48 PM
0

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

Thank you.


Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Aug 07, 2017 at 09:23 AM
0

Hi Tendayi,

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

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

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Aug 08, 2017 at 07:24 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded