Default Value 1

[maeling]

How can I make a calculated formula feilds' default value = zero ?

 

[IanWaterman]

Just add the condition to the fornmula using an If ...Then statement.

If condition = true the 0 else @formula

Ian

 

[maeling]

Thanks - I am a beginer - However below is the formula in question, can you tell me the exact syntax. If the database containds a null value then the formula field is blank.

{#Total on Hand} - {#Total Reserved}



In addition can you do the same on running total fields.

 

[synapsevampire]

The simplest solution is to use the File->Report Options->Convert null values to zero

But to address this question:

If not(isnull({#Total on Hand}))
and not(isnull({#Total Reserved})) then
{#Total on Hand} - {#Total Reserved}
else
0

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[maeling]

Wow that was easy - thanks