Problem in Formula

[rb2005]

Hi ALL,
I have created one formula say
formula 1 is (Sum ({tablename.colname}, {groupname}))
another formula
formula2 is
if formula1} > 0 then
({tablename.col})/{@formula1} *100
else
99
I want to supress the value of the formula2 with some condition. I am displaying formula2 in report in detail section. But the formula2 is returning same value even I have the conditional supress formula on that formula.
I am supressing the whole detail section if some column is zero.
Can anyone help me so that I can display formula2 if it fulfills the condition.
Thanks in advance,
RB

 

[Madawc]

What formula are you using to suppress? And suppress what - the field or the section?

Madawc Williams (East Anglia, UK)

 

[rb2005]

I have one supress condition for the section and other condition for the formula which I am using as a field in the report

 

[lbass]

You have to share the exact formula you are using for the conditional suppression of your formula field.

-LB

 

[synapsevampire]

A standard way to eliminate rows from displaying is to use Report->Edit Record selection->Group and place something like:

Sum ({tablename.colname}, {groupname}) = 0

-k