I dont know where i'm going wrong.....this is the formula I'm trying to use....IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: ''SYS08 Employee Details'.Role ] ELSE 0
@lcapon
So close! Try removing the double quote. So, so close.
Correct:
IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0
Yours
IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: ''SYS08 Employee Details'.Role ] ELSE 0
Thank you for getting back to me so quickly - unfortunately I now get.....this error....Data type mismatch: format other than LIST or DATE being referenced as a relation
So i just realised that the newly added 'role' hadnt been setup as a list - so I have gone back and updated and reimported :-0)
Its working!!!
Bingo! Nice job. You got this!
Can You please tell me how
receving the same error
Data type mismatch: format other than LIST or DATE being referenced as a relation
I am entering the correct formula and I am still getting all zeroes in my data. Can someone please help?
I am having similar issues on this. Can someone assist? I input those formulas and get all zeros. Is there an issue with the Roles list?
Hello @MiaKaercher Pls check your lookup fields are populating, those should not be blank.
hi there…could you clarify further i am not sure what you mean by that
I am using the exact same formula and still getting zeros :(
Hi you are multiplying bonus with respect to department and role from sys08 module. Hence pls check that respective fields in sys08 are having data or not? Also check for that combination you have salary data or not to multiply then only you will get Bonus calc no's.
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…