Formula Error

Pls can you help :

-----------------------------------------------------------------------------------------------------------------------------------------------------

The formula for 'EMP02 Employee Expenses By Dept & Role'.Bonus is invalid:

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

'EMP03 Employee Drivers by Role'.Bonus % is not a recognized line item or list member

-----------------------------------------------------------------------------------------------------------------------------------

Is it something to do with the data type? if so is it in SYS08 or EMP03.

Appreciate your help.

Regards

Richard

Accepted answers

Misbah

@rmat066sysf

If you look at your formula your module name is EMP03 Employee Drivers by Role which is the correct name but in your screenshot name of the module is EMP03 Employee Drivers by Dept & Role. Change the name of your module to EMP03 Employee Drivers by Role and your formula should work.

Let me know if it doesn't.

All comments

Misbah

@rmat066sysf

Initial reaction : Looks like you have written/typed the name of your line item Bonus % in your formula. Can you just refer and click on the line item Bonus % . I think it needs to be in single quotes as it contains a special character %.

rmat066sysf

Thanks, that the screen shot of my formula. Thanks for your help, still get the same error.

Misbah

@rmat066sysf

Can you please check the format of the line items in your SYS08 Employee Details module

1. Department - has to be list formatted on Departments

2. Role - has to be list formatted on Role

rmat066sysf

Hi Misbah

SYS08 Data is imported from a emplee detail by role txt file that has Role populated, so the format cannot be a list:Role...i guess.

Misbah

@rmat066sysf

Sir, you got to make it list formatted in order for LOOKUPs to work. You can import into list formatted line item as well.

rmat066sysf

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

IF Employed? THEN 'EMP03 Employee Drivers by Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

IF Employed? THEN 'EMP03 Employee Drivers by Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

IF Employed? THEN 'EMP03 Employee Drivers by Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

Hi Misbah

changed format to list:Role in SYS08

Attached are the screen shots of blueprint view, and the formula's that returns an error. Appreciate your help.

Thanks

Misbah

@rmat066sysf

Let me know if it doesn't.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…