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 an...
Microsoft Dynamics GP (Archived)

management reporter and non printing columns with CALC columns

(0) ShareShare
ReportReport
Posted on by Ian Richardson 4,150

hi folks

 

I am writing an income statement that will convert USD subsidiaries to CAD $.  Controller would like to list each USD company in USD (functional and reporting) one per column then have a USD column that adds together the USD and then a CAD column that adds all the CAD converted amounts together, we do not want to print the CAD equivalents of each of the US subs.

 

I am marking the CAD conversion columns as NP columns.  Then I Can have a CALC column that adds them together as requested

 

 

 

Notice that MR clearly says NP means Use in Calculations.

 

 

Now consider this MSFT webpage

 

http://office.microsoft.com/en-gb/performancepoint-server/calculation-formulas-in-management-reporter-HA010248430.aspx

 

that clearly states:

 

   The results of calculation formulas do not include the values in non-printing columns.

 

So which is it?

thanks!

 

Ian

 

 

 

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ian Richardson Profile Picture
    Ian Richardson 4,150 on at

    Sharing the wealth:

    referring to this webpage:

    office.microsoft.com/.../adding-a-special-formatting-option-in-management-reporter-HA010248431.aspx

    tells us

    Excludes the amounts in this column from printing in the report and from calculations.

    If you want to include a non-printing column in a calculation, refer to the column directly in the calculation formula. For example, the non-printing column C i s included in the following calculation: B+C+D However, the non-printing column C is not included in the following calculation: B:D

    So in my case I have to name each of the columns one by tedious one to get them to be included.  

    Should the range not work also?

    Ian

  • Keith Vogt Profile Picture
    Keith Vogt on at

    Hi Ian,

    The link you sent is for Management Reporter (MR) with Performance Point Server, which is likely a very small percentage of users who have MR installed.

    I tested this, and B:D would skip the NP amounts in column C. However, the B+C+D does include the NP values from column C.

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at

    hi Keith

    thanks for the reply and for checking.

    I too get the result of B:D would skip the NP amounts in column C. However, the B+C+D does include the NP values from column C.

    I posted to the community more because within MR the NP label implies that the columns will be included in CALCS, when they are not unless you name them specifically.  To then make jack and jill user like myself aware that MR will in fact ignore those columns unless referenced specifically.  Tedious when you have lots of companies (I have 22 companies to reference one by one, each company gets  a column)

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