Skip to Content

BPC Report : Local Calculation display for each Row & Total row in the Report

Hello everyone,

I have created a report in BPC 10.1 which shows Monthly Budget & Actual Data in columns for 12 months & I have 4 different G/L Accounts in row axis. TOTAL (Row 3) in the Row Axis is the Local members created which shows the sum of all the 4 G/L Accounts. My requirement is to create a Full Year (Column P) & to apply different calculations for all 4 G/L Accounts separately which I have shown in screenshot 1.

In Full Year Column P, I want to perform different calculations for the different G/L Accounts & TOTAL mentioned in the screenshot attached. I have created one column in excel after disabling the Activate Local member recognition and applied the excel calculation in the Full Year (Column P) for all the G/L Accounts & TOTAL which shows correct output for individual G/L Accounts & TOTAL but the after I refresh the report, TOTAL (14,774) disappears for Full Year (Column P) from the report ( Screenshot 2).

Kindly suggest , How to keep the TOTAL calculation for Full Year ( Column P) highlighted in screenshot 2 ( RED Color) on refresh of the report.

screen-shot-2.jpg (68.5 kB)
screen-shot-1.jpg (69.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 24 at 07:49 AM

    If you want an answer, please edit your question and instead of "Insert File" use correct "Insert Image". Currently your question is unreadable!

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 25 at 07:18 AM

    To my mind the logic of this report is strange and confusing! Different calculations in the same column will result in user questions!

    Theoretically you can use local member in Full Year with conditional Excel formula like:

    =IF(EPMDIM_CURRENT_MEMBER(ACCOUNT)="G/L1",...,IF(EPMDIM_CURRENT_MEMBER(ACCOUNT)="G/L2",...,IF....

    But I think you have to discuss the report logic with the customer again!

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 24 at 07:12 PM

    Sorry, but not clear what do you want to have in Total column! Please explain requirements in details!

    Also provide screenshot of your local member definition!

    Add comment
    10|10000 characters needed characters exceeded