In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Pulling information on the report designer using iff statement.
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 .
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.
Thank you KimM