Im trying to add an "if" formula to the report footer section of my report, but the calculation is blank, even added "else" to the formula to ensure that it is printing and the else value prints.

However, if i place the formula in the detail section of the report then the formula is displays correctly..

 

Eg, of the Formula

if {tablename.columnname} = "Value" then

 "1000"

else

 "2000"

 

Can you tell how to correct the formula so that the correct value displays on the Footer section when the value is exists in the detailed section?

 

knight