nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data type mismatch: format other than LIST or DATE being referenced as a relation

kebe

this is the formula

IF Employed? THEN Salary *'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role,LOOKUP: 'SYS08 Employee Details'.Department] ELSE 0

Comments

rishabh01

Hey @kebe

Make sure that item you are referencing in your lookup is list formatted. Currently, it is text formatted I believe.

Thanks,

Rishabh.

kebe

you are right, i formatted the role as text while it was a list

rishabh01

Great! You can accept the solution if it worked.

Quick Links

Recent release news

September 2026 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our September 2026 official release notes. There you'll find information on: User Experience KPI cards Mobile Zoom and pan KPI Conditional formatting Intelligence CoModeler Analyst Optimizer Disclosure Management Refreshed user interface Anaplan Data…
FCR Release 2608.3 Advisory: Notice of recent changes
Please take note of the following changes in our latest 2608 release: Multi-dimensional calculations now require valid rules. As of 2608, the multi-dimensional calculation process no longer runs when invalid rules are present - for example, a rule referencing an invalid member (one that no longer exists in the dimension).…