Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: management reporter and non printing columns with CALC columns

    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)

  • Keith Vogt Profile Picture
    Keith Vogt on at
    RE: management reporter and non printing columns with CALC columns

    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.

  • Suggested answer
    Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: management reporter and non printing columns with CALC columns

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans