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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter &q...
Microsoft Dynamics GP (Archived)

Management Reporter "IF" Formulas

(0) ShareShare
ReportReport
Posted on by Napolo 766

Hi-

I have never tried to use an IF Formula in MR, so I am not sure if it is possible. I used the Excel logic (see below), but it doesn't like the "=". 

Does the formula option allow IF statements?

Z_5F00_J-Formula.png

Z_5F00_K-Formula.png

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at

    Yes, you can definitely do If statements in MR.  No = sign in front.  An example would be:   IF B>100 THEN B ELSE C*1.25

    However, I am not sure if you can put text in a number field like you are trying to do.  I'll be interested to hear if that actually works.

  • Napolo Profile Picture
    Napolo 766 on at

    HI Matt!

    I tried this formula, but I must be missing something.  I am not too familiar with IF Statements in Excel either, that might be part of my issue.  This is what I am trying to mock. =IF(F7=0," ",I7/F7)

    IF G=0 THEN G ELSE K/G

    IF G=0 THEN K/G

    I tried this formula, but it wants me to replace Reason with ELSE. So I don't think the text portion will work.

    IF L<.01 THEN PROVIDE REASONS AND ACTION PLAN, IF K<-9999.99 THEN PROVIDE REASON AND ACTION PLAN

    I may need to setup a macro to set these formulas after export, but just thought I would see if I could skip that piece.  :)

  • Napolo Profile Picture
    Napolo 766 on at

    Hi Matt-

    Just wanted to share what I have learned:

    This is what we were able to accomplish with populating "TEXT".  However, if exporting to Excel, the values populate at 0 and the text is lost.  Also, the non text fields show up as "1".

    Below is the formula and the over-ride screen shot. 

    IF L<-.1 THEN 0 ELSE IF K <-9999 THEN 0 ELSE 1

    text.png

    For my particular situation, I work these reports into Excel. I just used the standard formula, and assigned 1 and 0 to the different values, so I could populate the TEXT in an excel macro via Find/Replace.

    Just wanted to share!

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at

    That's a neat little workaround.  Too bad it won't export out to Excel.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans