Questions Pulling information on the report designer using iff statement.

Acumatica Report Designer

Last Post by Teckla Kapuenene 5 years ago

3 Posts

2 Users

4 Reactions

2,674 Views

RSS

Posts: 14

Teckla Kapuenene

Topic starter

October 11, 2021 1:37 pm

(@teckla-kapuenene)

Eminent Member

Joined: 5 years ago

Hi Tim

Here is my scenario

i want to pull information on the report designer using the iff statement as follow

=IIf([APAdjust.LMTransactionCode]='80','Grant','0') and it works fine and i have a range from 80-89 and all those should print Grant if used on the transaction. On the same column IIf([APAdjust.LMTransactionCode]='60','Loan','0') and this range is 60-69 and all those print Loan if used on the transaction but if i add this then it doesnt work .

Please assit

2 Replies

Posts: 19

KimM

October 13, 2021 5:23 pm

(@kimm)

Eminent Member

Joined: 5 years ago

You have to nest your IIFs. =IIf([APAdjust.LMTransactionCode]='80','Grant',IIF([APAdjust.LMTransactionCode]='60','Loan','0')) Not sure if I have that nested exactly right or not but it will get you close.

Posts: 14

Teckla Kapuenene

Topic starter

October 15, 2021 4:36 am

(@teckla-kapuenene)

Eminent Member

Joined: 5 years ago

Thank you KimM

It worked.

12 Forums
2,533 Topics
11 K Posts
110 Online
2,437 Members

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

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

By using this website, you agree to our Terms of Use (click here)