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

Pavana
New Contributor

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

 

1 REPLY 1
Misbah
Moderator

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

@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