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

Pavana

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

This is the expense drivers module

THis is my Target module with Formula

 

Misbah

@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