I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for 2 weeks now.
The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04:
It draws from SYS08:
I keep getting the wrong number whether I use EMP02 or EMP03 in the formula.
Can anyone help an amateur Anaplanner on where I am going wrong? I have a feeling there's something wrong with EMP02. Maybe that I'm not using region in the formula??? For example, here's the formula for phone costs in EMP02:IF Employed? THEN 'EMP03 Employee Drivers by Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0
Try using the formula mentioned below:
'EMP02 Employee Expenses'.Car Costs[SUM: 'SYS08 Employee Details'.Region, SUM: 'SYS08 Employee Details'.Role]
'EMP02 Employee Expenses'.Phone Allowance[SUM: 'SYS08 Employee Details'.Region, SUM: 'SYS08 Employee Details'.Role]
'EMP02 Employee Expenses'.Medical Benefit[SUM: 'SYS08 Employee Details'.Region, SUM: 'SYS08 Employee Details'.Role]
Hope this helps you up !!
Happy Learning 🙂0