General information
Category:
Reports & Report designer
Title:
Nesting IIF(), is this possible
I am using the IIF() to get a value for a field in a report and need to nest the IIF(). Can this be done?
The expression I am using for a field in a report goes something like this:
IIF(hank.pla_level = '1st', IIF(HANK.PLA_WITH = 'Ideal',ROUND(HANK.AMOUNT *.3,2), ROUND(hank.amount*.275,2)), ROUND(hank.amount*.5,2))
It looks good to me, however my logic may have a flaw I cannot find or nesting this type of expression may not be valid... I keep getting a 'syntax error'. I am sure there is an easier way to accomplish my goal, however, I would really like to know if nesting the IIF is possible and what I could be doing wrong? Any ideas would be great!
Also, I am new at this please be kind :)
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only