Well now that I know that fields don't slide in header/footer how about this one.
I set this field to HIDE if it equal zero to make the reports cleaner.
It works on the some the of the field on the first sub-summary, but none after that.
Can it be that the fields aren't really 0 but are the something like 0.000001?
That's a great point.
With floating point types (currency or whatever), never assume equality with zero.
Even if zero is "displayed", it may not be zero internally.
So, with currency maybe you could HIDE IF <Field_name> < 0.01 (less than a penny)?
I suspected that and changed the field to hide if <1 as a test.
I changed the field format to general so I could be sure.
Works consistantly in the first sub-summary section but not after.
"Sub Summary section" is, I suspect the key phrase here as to why this is happening.
If your hide object when expression is checking a summary field, it's not accessing the subtotal displayed in that summary field in the sub summary part. It's accessing the Grand Total computed over the entire found set. Use the GetSummary function to access the same sub total shown in your sub summary part if this is in deed a summary field that you are checking for a value.
OK, but whydoes it work on the first sub-summary section?
Is it actually a summary field?
Yes it is a summary field.
Would you please post a minimally sufficient FMP12 example that demonstrates the issue?
What happens when you use the field name instead of Self in the hide object field?
Can you also try what happens with conditional formatting?
Retrieving data ...