General information
Category:
Reports & Report designer
Connie,
I know you already solved the problem, but to shorten the expression you could try:
ROUND(hank.amount * IIF(hank.pla_level = '1st',IIF(HANK.PLA_WITH = 'Ideal',0.3,0.275),0.5),2)
Just my $0.02
Rex
>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 :)
Previous
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