web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

(MR) Calculations with column letter "IF"

(1) ShareShare
ReportReport
Posted on by 20
Hello Community,
I have a huge report that has a lot of columns, it goes from A all the way to TZ, many columns have different calculations such as HB-HA for example. However, we have a problem with the column "IF", because when we try to use it in a calculation like this: 
IF+HP+GZ+GJ+EA
 
The MR gives me an error and tells me that the conditional expression is incomplete and that it needs a "THEN".

Now, I understand this happens due to the fact that the word IF is a reserved word for conditional calculations and such, the question, how do i use the column with the letters "IF" then? Or can I simply not use that column in calculations?
Captura de pantalla 2024-11-04 141423.png
Categories:
I have the same question (0)
  • Devon Southall Profile Picture
    160 on at
    oh... wow... hmmm... I bet they never thought you would have THAT many columns!! Yikes!
     
    I know what I would do.    Just add a non-printing column in column "IF".      Somedays you can't fight Microsoft.   
    :-)
     
    Good luck?
     
    Best,
    Devon
     
     

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 509 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 375

#3
Adis Profile Picture

Adis 268 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans