Hi guys,
I am working on Sales Planning application, which needs to calculate two things. First, to calculate Quarter amount from Posting Period Amount and second, to calculate Rate/Unit for each record. Formula to calculate Rate/Unit is
Rate/Unit = Amount of the posting period / Amount of quarter for that posting period.
e.g. PP Quarter Amount Rate/Unit
1 1 100 100/600
2 1 200 200/600
3 1 300 300/600
Below are sample transaction records that I have to work with to get the desired results. I am using Fox Formula to calculate.
Changing parameters in below records are :
Sales Org 1000 & 1001
Product : so many products
Franchise : 10
-
Record Header-----
Sales Product Franchise Quarter Posting Amount Rate
Org Period(PP) /Unit
-
Record Starts Now -
1000 5001 1 # 1 100 #
1000 5001 1 # 2 200 #
1000 5001 1 # 3 300 #
Upto PP # 12
1000 5001 2 # 1 100 #
And so on upto Franchise 10
1000 5002 1 # 1 200 #
And so on many products
1001 5001 1 # 1 100 #
And so on for SO 1001.
-
Records end here -
Is this possible with Fox Formula? How?
Any help will be highly appreciated and rewarded.
Thanks,
MD