Microsoft Dynamics 365 | Integration, Dataverse...

Management Reporter / Report Designer How to Reference Column IF

(3) Share

Report

Posted on by EM-24121627-0

I have a report with a column definition that spans hundreds of columns. I have a few hundred variance columns that use the simple CALC of column - column that all work except one. The one that doesn't work has the formula IF-TA because it thinks I'm trying to use an IF statement. I've tried @IF-TA and @IF-@TA and it still returns an error. How do I reference column "IF"?

Categories:

Dynamics 365 general

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Vahid Ghafarpour 12,228 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

you need to enclose in brackets []

using it with calc would be best option

CALC([IF] - [TA])

Was this reply helpful? Yes No
EM-24121627-0 11 on at

Like (1)

Report
Copy link

Link copied!

I tried the syntax in the attached two pictures, but neither worked. Is there a version difference or some other constraint?

Was this reply helpful? Yes No
Paolo Cecchelli 610 on at

Like (0)

Report
Copy link

Link copied!

Hi, there was already a discussion on this topic, unfortunately without a definitive answer if not creating a column with the same settings as the IF column and referencing that one instead:

https://community.dynamics.com/forums/thread/details/?threadid=f7bb0d8f-0b46-f011-877a-7c1e525a8110

1 people found this reply helpful.

Was this reply helpful? Yes No