FOX Formula

[Former Member]

Dear All,

i have characteristic(User defined) called Average monthly cost which has a value 35.00 and two keyfigures,(NUMOBILES and 0AMOCAC)

I want to calculate Average monthly cost * NUMOBILES=0AMACAC

FOR EX: 35*2=70

Thanks in advance

Imran

[Former Member · Accepted solution]

Simple FOX formula:

= { average montly cost} * .

D

[Former Member · Accepted solution]

Thanks D

After executing the formula, Where can i assign the formula in the planning layout,

Do i need to assing formula as a variable??

Thanks

Imran

[Former Member · Accepted solution]

you need to first create a planquery. In this planquery you can define your functions.

I propose your read the SAP help on plan queries. Here is the link for SAP HELP BI IP. It is too long to explain this in detail.

http://help.sap.com/saphelp_nw04s/helpdata/en/43/f234619e3c4c5de10000000a155369/frameset.htm

regards

D