Skip to main content
Solved

IIF condition is not working in a report


Forum|alt.badge.img

In a report I need to fetch data from GLHistory DAC, in my report table schema I have join GLAccount also. I need to get the sum of GLHistory.FinBegBalance where the Account Id is equal to 7000. for that I add variable and set its value base on a IIF condition. but it is not working.

Herewith I have attached my report, inside the details section I have define the variables. currently I have changed the if condition as bellow for debugging purposes

=IIf( [Account.AccountCD] = '7001',True, False) 

I tried different ways such as

=IIf( [Account.AccountID] = 7001,True, False) 

=IIf( [Account.AccountCD] = 7001,True, False) etc. but nothing works

Best answer by PDharmasena10

This issue had occurred due to a mistake in hardcoded values. ðŸ˜Œ

 

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img
  • Author
  • Varsity I
  • 49 replies
  • Answer
  • August 15, 2024

This issue had occurred due to a mistake in hardcoded values. ðŸ˜Œ

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • August 15, 2024

Thank you for sharing your solution with the community @PDharmasena10!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings