Any Limitation in Conditional Running Total

[CrystalReports9]

Hi

I am using Crystal Report Developer Edition 9.0

Created the Running total field and evaluate it using formula. If the formula success then i am getting the running total field's value.
---------
Question:
----------
But i want, if the formula fails then the running total field value should return the value '0'. How to do it?

Thank u

Rgs
Antony

 

[lbass]

Assuming you mean you already have a calculated running total, possibly in a group footer, which you want to evaluate using a formula, then try this:

if {#yourrunningtotal} > 1000 then {#yourrunningtotal} else 0 //substitute your criteria for the "> 1000"

Is this what you were looking for? I'm wondering whether instead you have a running total that is sometimes blank in the group footer--if that is the case, it is probably encountering nulls along the way, and you have to allow for that. If this is the problem, then please explain what field you are using for the running total, and if you are using a formula to evaluate the field, please provide it.

-LB

 

[CrystalReports9]

Hi LB

Yes. I got the solution. Thank You. Appreciated your help.

Rgs
Anto