Quarterly calculation

[Former Member]

Hi All

We have a situation were we want to calculate the following

Q1

M1 M2 M3

Kf1 100 100 100

Kf2 10%

Kf3 300x 0.1 = 30

Kf1 is input kf which is available in monthly buckets

Kf2 is input kf which is percentage value which is available only in a quarter

Kf3 is calculated kf where kf1 value for (M1 + M2 + M3 ) * kf2 at a quarterly level . And the result needs to be displayed in the last month of the quarter

Are there any ideas of achieving this in IBP ??

Regards

Chirag

[ankpatel · Accepted solution]

Hi Chirag

Yes, you can achieve this in IBP using model configuration and HCI.

First, you have to bring KF1 at the QTR level KF1@QTR = SUM(KF1@MTH)

Second, Do your calculation at QTR level KF3@QTR = KF1@QTR*KF2@QTR

Third, using HCI do the mapping to populate KF3@QTR level value to the specific month of the QTR.

Regards

Ankur

[Former Member]

Thanks Ankur ..

When u say HCI , would it be a HCI job ?? also do you think Attribute transformation will help in this case if we can identify a condition which will give me the Month in the quarter ??