### 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)
10|10000 characters needed characters exceeded

• Apr 24, 2018 at 07:49 AM

10|10000 characters needed characters exceeded

I have done the required changes and now you will be able to see the screen shots.

Thanks

Komik Shah

• Apr 24, 2018 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!

10|10000 characters needed characters exceeded

P.S. Never use Local member recognition, always create local members manually!

• Apr 25, 2018 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!