For some reason I can't figure out the formula set up for questions 3 & 4 bonus and phone costs by role. I am wondering if my references are mismatched. Any help on this is appreciated as I feel like I am struggling by myself here and can't ask anyone or anything to help me out.
Can you please share the related modules & line items for which you are getting your answers wrong. Will try to see what issues are there in the formula. Don't paste your questions here please
Thanks,
Misbah
matching roles in the Employee Drivers by Role module to the SYS08 Employee details module in order to pull over the medical costs by role is my issue.
My formula: 'Employee Drivers by Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department, SYS08 Employee Details'.Role]
HI, I guess there is an issue with the module name you are typing as the source module,
'EMP03 Employee Drivers by Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] this is the formula i used and its working fine
Maybe you are missing complete module name
Also I get this error:
Data type mismatch: format other than LIST or DATE being referenced as a relation
@kshipley Your module name in the formula seems to be wrong.
this is the explanation I am getting on my formula
Data type mismatch: format other than LIST or DATE being referenced as a relation
What are your applies to and formatting settings for each of the following?
Specifically, there are couple things I'd point out to you about the formula you used:
In either case above, you should get a syntax error when trying to submit the formula. Make sure you look (and share, if you need to ask for assistance) at what the error message says as it can help narrow down what the issue is.