Skip to Content
0
Former Member
Nov 30, 2006 at 05:51 PM

Fox - Calculate Quarter Amount from Posting Period Amount.

89 Views

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