IIF error

starhu

Hello,

I have the following memo:

[IIF( <frxMydataSet."conversionNo"> =1, [SUM( <frxMydataSet."RemainingNumber">*<frxMydataSet."Price">
,MasterData1) ] ,[SUM( <frxMydataSet."RemainingNumber">*<frxMydataSet."Price">/100
,MasterData1) ])]

... and it gives the error: Could not convert the variant of type (array variant) into type (OleStr).


Thank you in advance

gordk

try replacing the internal [] sets with () there should only be 1 overall set of [] braces

starhu

gordk wrote: »

try replacing the internal [] sets with () there should only be 1 overall set of [] braces

Thank you very much! It works!