cancel
Showing results for 
Search instead for 
Did you mean: 

BPC NW 10: calculate cells in input form (based in other input forms)

Former Member
0 Kudos

hi bpc gurus:

I m building 3 input forms on a single sheet, like this:

But I have a doubt on how to build the Input Form "Cost", since every cell of this input form is calculated by multiplying input form "Sell" and input form "Rule" (the user doesnt have to input anything in input form "Cost",  BPC must calculate every cell). How can I achieve this? Obviously when the user press "Save Data", BPC must save the data of the 3 input forms.

is there some way to achieve this?

PS: the number of rows of these 3 input forms is the same, they can change based on the context values which affect the 3 input forms.

regards

jav

Accepted Solutions (0)

Answers (3)

Answers (3)

Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Jav,

You can use EPMCopyRange() Function for Input Form "Cost". In function give the report id, range.It will apply both formatting and formula to the whole report.

former_member222556
Contributor
0 Kudos

Hi Jav,

1) You can write script logic in Default to calculate the Cost.

     [Dimension].[COST] = [Dimension].[SELL] * [Dimension].[RULE]

     if you want the Cost values to be saved in Database. This logic will calculate Cost automaticaly whenever you save the Sell or Rule.

2) You can write dimension member formula for Cost

     [Dimension].[SELL] * [Dimension].[RULE]

     This will be calculated at runtime.

3) if you are using BPC 10 , you can use Local Member Formula for the same.

Best Regards

Obaid

former_member186338
Active Contributor
0 Kudos

Hi Jav,

But why don't use script logic in the default.lgf to perform this calculation?

B.R. Vadim