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
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.