PRevious field

[dandman71]

I am creating a report which has a running total associated with it for employee earnings. As an employee is paid up to 14000, an amout is calculated in another formula field. I have created the formla field to calcualte the amount. HOwever,if a person is paid cumulativley to 13,500 it will give a value, but the next entry is 15,200 and there is no value caluclated because it is seeing it as over the cap. I need it to calculate on other 500 dollars that should be charged before the cap was hit. IS there a way to accomplosih this in a PREVIOUS function of some tpe. thank you

 

[lbass]

Let's say that you are calculating 5% of earnings up to $14,000 and that you are accumulating earnings in a running total {#sumearnings}. You could create a formula like the following:

if {#sumearnings} <= 14000 then
{table.earnings} * .05 else
if {#sumearnings} > 14000 then
14000 * .05

-LB