Calculation - Latest Salary
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?
P.S. Yell if you need more info.