Level1: EMP03 Employee Drivers by Role does not return any data

Hi Experts,

Below formula does not return any data, i tried many different types but it does not work. but the EMP01 employee driver returns the data.

'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role, LOOKUP: 'SYS08 Employee Details'.Department]

Regards,

Kiran.

Accepted answers

All comments

einas.ibrahim

Hi @kmanku ,

Could you please provide your Target the line Item you are writing the formula for. I had done the level 1 a while back and I don't recall the details by heart.

Also, if you could, please send screenshots.

-Einas

kmanku

Hi,

Thanks for the response, this is happening when calculating the Bonus in "EMP02 Employee Expenses" , Bonus % is available in "EMP03 Employee Driver by Role" when i write a formula to get the bonus % it is not pulling any data from the "EMP03 Employee Driver by Role".

i did not get any error in the formula, but it did not get any data back. not sure how can i debug the issue as well.

Akhtar.shahbaz

Hi @kmanku

Your formula looks correct to me, Can you drill down by pressing F8 the bonus line item of your EMP02 Employee Expenses??

First check you Employee? is checked or not if not then it will take else condition which is 0
Check whether your salary has some number or not? and also check the bonus %? if any of them is 0 then output will be 0.

Thanks

Akhtar

kmanku

Hi,

Emp is active and Salary and Bonus % is exist, i have checked all that.

i have removed the if condition and checked as well.

Regards,

Kiran.

Akhtar.shahbaz

Hi @kmanku

Can you send me the Screenshot of SYS08 Employee details and Drill down of EMP02 module for 1 one of the active employee?

Thanks

Akhtar

Akhtar.shahbaz

Hi @kmanku

As you mentioned you have salary and bonus % data then one of the possibilities I can think of your SYS08 module are missing either Role or Department Mapping with the employee so that your lookup is not working properly

Thanks

Akhtar

kmanku

thanks for the response, i did check the SYS08 module it has data in department and Role data populated.

Akhtar.shahbaz

Hi @kmanku

Can you please share the screenshot of your Bonus line item (drill down) of EMP02 module and EMP03 module?

Thanks

Akhtar

vivekpratap2015

Hi All,

Even teh same issue I am facing please help me out to solve this issue I am attaching the doc which has all details.

Lookup_Function_issue_94145.docx

jessmathomas

I am having the same issue. I added in my updated formulas for bonus, car costs, phone costs, and medical costs and did not get an error message. Instead, the values are just zero. I think it has something to do with the formula column being blank in SYS08 (SEE ATTACHED).

Capture_128458.JPG

Hali

I am also facing the same issue, the screen shot attached

EMP03_Employee_Expenses__128553.docx

MAwude2010

Hi Jess,

How did you progress with the training? Im having same issue loading Roles into SYS08

Please help if you have managed to overcome this issue

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…