Page 1 of 1

Changing Salary Calculation in Fast Formula

Posted: Thu Mar 07, 2013 5:15 pm
by gandham
Currently we have a formula where salary calculation is fixed i.e. 30 days. How can i change monthly salary calculation i.e. salary/30 to a calculation where annual salary will be divided by 365 days and to be multiplied by the number of days available in the respective month. I appreciate an approproate answer. Thanks in advance

Posted: Thu May 02, 2013 4:22 am
by saudapk
Hi,

You can use current salary and annualization factor DB Item to get yearly salary and then division by number of days of the year and multiplication by no. of days of the respective month. The count of days of the year and count of days of the month can be achieved using normal date operators.