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
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'