Help needed in a Formula Field 1

[saran26]

Hi All,

I have formula field in my report with the following formula, it always print 0.00 , even though there are some records with the state "Open".

Please help us out.

whileprintingrecords;
numbervar i:=0;
if{ClearQuest.state}= "Open"
then i=i+1;
i

Thanks
Saran

 

[lbass]

What are you trying to do with this formula? No need for a variable here. Just use:

if {ClearQuest.state} = "Open" then 1

If you trying to count those that are open, then right click on this formula and insert a summary (sum, not count).

Note that in your formula, you were resetting it to zero for each record. You should have just declared the variable. If you need a reset at a group level, that should be a separate formula placed in the group header.

-LB

 

[saran26]

Thanks it works.

Saran