Hiding when Summary Field is empty or zero

[bcooney]

I'm running into an issue hiding a text object in a sub summary part when a summary field in the same part is empty or zero.

I created a little demo file to show my issue. I resorted to using Get Summary, but that still doesn't work in my solution (but it's much more complicated report there).

I'd appreciate feedback as to why I needed Get Summary.

tia,

Barbara

summaryhide.fmp12

[Steve Martino]

It works when I use this:

GetSummary ( invoice_line::total_of_discount ; invoice_line::category ) <1

I had this problem before, and thought I was 'doing it wrong', so I used the  < 1.

[bcooney]

Well, I realize that get summary is needed because these are subtotals. Still not working in my actual file. I'll try <1 rather than =0. 

[bcooney]

Just an update. My issue was that the break field needs to be in the same table (even if it's an unstored calc) as the summary field. The hide calc = GetSummary ( summary_field; break_field) = 0. (The summary part is sorted by the break field).

hope this saves someone else the hours it cost me!