Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Fox Formula!!

Hi,

i need to help for fox formulas in BI-IP. i want to calculate net revenue. i have two data cubes.First cube is SALES, second is PARAMETER and i created multi-provider that include these cubes.

NET REVENUE= GROSS REVENUE- DISCOUNTS. this is my formula. after i calculate this , i must change type of currency and This value is calculated on the monthly average exchange rate which is comming from parameter cube.my currencies are turkish lira(TRY), euro(EUR) and dollars(USD).

in this formula, type of currency is 00.for example i want to convert it to 10 for TRY and to 20 for EUR and to 30 for USD.

for example;

DATA CUR TYPE 0CURRENCY.

DATA TCUR TYPE 0CURTYPE.

FOREACH CUR,TCUR.

{Net Revenue,CUR,00}={Gross Revenue,CUR,00}-{Discount,CUR,00}

{Net Revenue,TRY,10}=.......

{Net Revenue,EUR,20}=.....

{Net Revenue,USD,30}=....

i how can i do it ???

Former Member
Not what you were looking for? View more on this topic or Ask a question