format of mapping used for lookup doesn't match any dimension of the source

Team, I have one System Module and other Exp drivers module. Created a new module and adding formula to get the expenses numbers. But am getting format error.
This is the snapshot of my Systems module

Pavana_0-1631025077737.png

This is the expense drivers module

Pavana_1-1631025101885.png

THis is my Target module with Formula

Pavana_2-1631025174487.png

 

Tagged:

Answers

  • @Pavana 

     

    Use LOOKUPs on Department and Role and NOT Regions and Role.

     

    Your formula should look like

    EMP 03 Employee Drivers by Role.Car Allowance[LOOKUP: SYS08 Employee Details.Department, LOOKUP: SYS08 Employee Details.Role]

     

    Misbah 

  • the format of role should be 'list' not 'text'