Skip to Content
0
Former Member
Mar 24, 2009 at 12:54 PM

how to implement this planning function using Fox formula

39 Views

Hello,

I am new to Fox.

I want to implement this complex logic in a planning function

i have A (Kf X from infoprovider Z_A), B (Kf Y from infoprovider Z_B) & moreover there is one more condition,

If current FISCPER > variable value of FISCPER

KF Z = KF Z1 (from Cube C1)

Else KF Z = KF Z2 (from Cube C2).

for a particular calender week,

X = ( Y * Z ) / (summation of (Y * Z) for each week of the whole year)

I know it is complex.

but i have to implement this in a planning function.

The aggreagtion level is built on a multiprovider having A, B , C1 & C2.

Can someone help me out with the FOX formula for this? or is there any better way to do this.

Thanks john