Questions The expression contains undefined function call IIf()

Acumatica Report Designer

2 Posts

2 Users

0 Reactions

8,962 Views

RSS

Posts: 34

fozzie

Topic starter

October 14, 2017 9:01 am

(@fozzie)

Trusted Member

Joined: 8 years ago

Hi Everyone,

I am trying to nest two iif statements in Acumatica Report Designer:

=IIf([ARDunningLetter.DunningLetterLevel]='1','ATTENTION PLEASE',IIf([ARDunningLetter.DunningLetterLevel]='2','SECOND NOTICE'),'FINAL DEMAND')

But I get an error which I do not understand:

The expression contains a call of an undefined function IIf().

1 Reply

Posts: 3193

Tim Rodman

Admin

October 14, 2017 9:04 am

(@timrodman)

Famed Member

Joined: 10 years ago

Hi Fozzie,

I think the problem is due to a misplaced closing parenthesis.

Try moving the closing parenthesis highlighted below to the end of the formula.

So your formula would now read like this:

=IIf([ARDunningLetter.DunningLetterLevel]='1','ATTENTION PLEASE',IIf([ARDunningLetter.DunningLetterLevel]='2','SECOND NOTICE','FINAL DEMAND'))

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed