This content has been marked as final.
Show 2 replies

1. Re: Fast Formula Calculation logic
877722 Nov 9, 2012 11:30 AM (in response to 877722)Gurus,
Any help on the issue.
Your help is much appreciated
Thanks 
2. Re: Fast Formula Calculation logic
975131 Nov 20, 2012 8:32 AM (in response to 877722)Hi,
It's a little hard to show how to do it. Let me try to explain as below.
The most concept about Fast Formula working is Fast Formula is based on Element calculation order.
As your requirement:
1.A element for deducting current period.
2.Need to accumulate deduction amount over past periods.
3.Need to calculate base earnings at current period to calculate 25% amount limited.
4.Rest Deduction Amount = (Total Deduction Amount  Accumulated Deduction Amount)
IF Rest Deduction Amount <= current period earnings 25% amount then
Current deduction amount = Rest deduction amount
Else
Current deduction amount = current period earnings 25% amount
is that right?
Here are steps suggested:
1.create a "Voluntary Deductions" element A, and two input values:
Pay Value : stored fast formula calculation results
Total Deduction Amount : fixed total amount you need to deduct. When you add this element to a assignment, you should enter this amount at the same time.
This Element's Priority should be setted bigger than those earnings elements' priority.
2.create a balance A for base earnings.
Inorder to get base earnings total amount for calculating 25% amount.
3.create a balance B for accumulating deduct amounts of element A.
4.create fast formula of element A:
(1) Get Total Deduction Amount from element A's input value "Total Deduction Amount"
(2) Get Balance Amount of balance A
(3) Get Balance Amount of balance B => Accumulated Deduction Amount
Dimensions: Assignment Inception To Date / Assignment Processing Period to Date
(4) Calculate current period earnings 25% amount = Balance Amount of balance A * 25%
(5) Calculate Rest Deduction Amount = Total Deduction Amount  Accumulated Deduction Amount
(6) Calculate:
IF Rest Deduction Amount <= current period earnings 25% amount then
Current deduction amount = Rest deduction amount
Else
Current deduction amount = current period earnings 25% amount
(7) Return Current deduction amount to element A's input value.
Best Regard's,
Changhua