Calculated Fields

[TomPerkowski]

I am trying to revise a report that requires an IIF() in a calculated field. (Pdox4.5)
(sum([extension],group) * (1 - [Orderhdr->discount])) +
iif([show->TaxServChrg] = "Y",[show->ServChrg],0) generates a syntax error. In testing, I changed the [show->ServChrg] to 1 and I receive no error and 1 is added. If I delete the IIF and just add [show->ServChrg], that gets added. Where is the syntax error coming from?
TIA,
Tom

 

[Miros]

Make sure [show->ServChrg] is numeric.

Just a thought,
Rosalie Dieteman

 

[TomPerkowski]

Thought of that and yes, it is a numeric field. One of my tests was to substitute the numeric value 1 for show->servchrg. That works fine; but it doesn't help explain the syntax error.

Thanks,
Tom