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 

[Ianmao]

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