Running Total Formula

[Rob2k2]

I am using a running total field to sum up a field (field1) based on an evaluation formula on another field(field2).

However if the evaluation formula is not met i.e. the condition of the formula is not satisfied then it wont return anything.

Is there a way to return a 0 value instead of nothing?

Any help would be grately appreciated.

 

[lbass]

I think you would only get a null running total if you have a null in one of your fields. Try replacing {field1} with:

if isnull({field1}) then 0 else {field1}

For {field2}, establish a rule for nulls also that fits your needs:

isnull({field2}) or {field2} = yourvalue//or

not isnull({field2}) and {field2} = yourvalue

-LB