How to add to the Lookups

1 post / 0 new
pganguly A+ 0
How to add to the Lookups

Hi,

Being new to Modano, I may not have looked in the right place. I even searched the Community forum but couldn't find anything relevant.

Basically, I am trying to create a Salary forecast which would be based on weeks and not months. The weekly or fortnightly pay to be the made to employees would be based on their annual salaries. I want to include under Periods in Period under the Lookups, 52 weeks which should then drive the salary in the Rev_Exp tab what would be forecasted salary for each employee be based on the number of pay runs each month.

Put simply if an employee earns $130,000 per annum, his monthly salary would be $130,000/52*4 if there are 4 weeks in that month.

Should you need any further info, kindly let me know.