AnsweredAssumed Answered

Calculation - Latest Salary

Question asked by ChristofferRexen_1 on Jul 2, 2015
Latest reply on Jul 2, 2015 by WilliamThurmes


Calculation - Latest Salary


Hello everyone

I'm using FMPA 14 / OS X 10.10.4

I'm trying to figure out, how to get a calculation working, based on our customers salary.

John Doe - Salary X - 01.01.2015

John Doe - Salary Y - 01.06.2015

John Doe - Salary Z- 31.12.2015

I need a calculation, which takes basis of the latest salary, although not future dates.

In this example, John Doe's salary Y 01.06.2015, would be the one to calculate atm.

As soon as we hit 31.12.2015, the calculation should take basis of salary Z.


Now furthermore, we do get salary information based on monthly salary, which I would like to spare my colleagues the trouble to calculate manually - which leaves mistakes.

Is it possible, again with a calculation, to calculate a yearly salary to monthly and vice versa, by using 2 different field, Field 1 - Yearly Salary / Field 2 - Monthly Salary.

My colleagues then type - depending on the salary information they get - yearly or monthly - in the desired field - the other field, which is not populated, then get's populated with the same salary, but then specified either yearly or monthly?

Best regards


P.S. Yell if you need more info.