Calculation Error for Formula

tspoon
tspoon
in Integrations and extensibility

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:

tspoon_0-1647808316984.png

 

 

tspoon_1-1647808316984.png

 

 

It draws from SYS08:

 

tspoon_2-1647808316985.png

 

 

I keep getting the wrong number whether I use EMP02 or EMP03 in the formula. 

 

EMP02:

 

tspoon_3-1647808316985.png

 

tspoon_4-1647808316985.png

EMP03:

 

tspoon_5-1647808316985.png

 

tspoon_6-1647808316985.png

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

Tagged:

Answers

  • ankit_cheeni
    ankit_cheeni

    Hi @tspoon 

     

    What would be helpful is if you can show the dimensions in the source (Employee Expense module) and target module. That will help you identify the line items across which you'd sum/lookup. 

     

    Thanks!

  • TimWard70
    TimWard70

    Also, check the summaries on your line items - % would rarely by sum - more often formula

  • tspoon
    tspoon

    Here are the dimensions from the Employee Expense module:

    Screen Shot 2022-03-21 at 9.53.16 AM.png

    And here is the list that it is referencing for the pages: 

     

    Screen Shot 2022-03-21 at 9.53.39 AM.png

Categories