Adding Running Total Fields using a formula

[rafeman]

Hi there,

I have many running total fields which need to be be added up to produce totals. I have tried a formula whereby I simply do RT+RT+RT. This works great, unless one of the running totals has a zero value, whereupon I get nothing printed. If I take the zero running total out it works. What am I dong wrong?

 

[synapsevampire]

It's not that the RT has a zero value, it's that is has a null value, which is common to SQL and many programming languages.

Try:

IIF(isnull({#RT1}),0,{#RT1})
+
IIF(isnull({#RT2}),0,{#RT2})
+
IIF(isnull({#RT2}),0,{#RT2})

-k

 

[rafeman]

Thank you very much. All sorted