Hi,

 

I am doing a forumla that returns records, and then I am doing a summary (which is Maximum) on that field and displaying it in the footer of my report. It loops through about 6 rows. 4 of the rows contain numerical data but the other two return null. The reason being if the result is Refused or Don't Know then it equals 0. But I don't want to show a 0, what I want to show is N/A.

 

So I am going to format object on my summary field and to the formula editor next to Display String and I have this entered:

 

If ({command.Result} = "Refused" Or {command.Result} = "Don't Know") Then
"N/A"
;

 

And it works fine. It shows N/A for the two rows where the above argument is correct. The problem is is does not show anything for the other 4 rows when returned. Dor some reason it seems to have either deleted or hidden these results.

 

Any ideas? thanks!

If ({command.Result} = "Refused" Or {command.Result} = "Don't Know") Then
"N/A"
else

currentfieldvalue