Management Reporter / Report Designer How to Reference Column IF

(1) 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 (2)

Answers (0)

Vahid Ghafarpour 12,168 Super User 2025 Season 2 on at

Like (0)

Report

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 4 on at

Like (0)

Report

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