Suppress footer based on Sum of Field

[kimprogrammer]

Hello
I created a field in my footer report which is a sum of the amount in the detail. I would like to suppress the footer if the sum amount is less than or equal to 75.

In the footer section the field is named SumofAmount1:Sum of SwipeAccmulativeHours.Amount

I'm not sure what to write as a formula. I've tried but get an error when I save it:
if (SumofAmount1 <= 75) then
false
else
true;
----------------
I've also tried
if Sum(SwipeAccmulativeHours.Amount) <= 75 but that is not it either.

Thanks for the help

 

[lbass]

What footer? If you mean the report footer, go into the section expert->report footer->suppress->x+2 and enter:

sum({SwipeAccmulativeHours.Amount}) <= 75

If you mean a group footer, select the group footer in the section expert->suppress->x+2 and enter:

sum({SwipeAccmulativeHours.Amount},{table.groupfield}) <= 75

-LB

 

[kimprogrammer]

I did mean the group footer. I did not know about the table.groupfield.

Thank You - it works great now