Notifications
Announcements
No record found.
=Sum(IIF(Fields!BusinessGroup.Value = "NA",0,Fields!Balance01Cur.Value))
I moved your question to a D365FO forum. Now can you pleae elaborate your question? You posted a piece of code and forgot to provide any explaination of what problem you have with it, or what else you need from us.
Hi Martin,
I need to calculate the amount where the business group is not equal to "NA" if it is then I need to consider it as 0. So in the expression, I wrote the above code. It is not working though.
What exactly do you mean by "not working"?
What if you wrap IIF() in VAL()?
Hi Vikash,
Did you put the expression on the same tablix where data is located or it's outside the tablix? Does your expression return 0 or sum all lines (NA and not NA) or something else? Are you sure that NA is real value for the field and it's not shown in the tablix with another expression for example is the value is empty?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 663 Most Valuable Professional
André Arnaud de Cal... 540 Super User 2025 Season 2
Sohaib Cheema 348 User Group Leader
