@rahulharjai - one of the formulas you mentioned doesn't work because the result is a true or false format so that needs to be changed.
Try to break down what you're trying to achieve in to small steps.
Then you can think about the relationships you need to make as mentioned by @JaredDolich by using either sum or lookup or select (try to avoid select where possible),
Then you can build the solution.
I hope this helps!
Hi @Jitendra.Vishnolia ,
Apologies for delay in response.
Please find the attached EMP01 Module Blueprint View.
Thanks & Regards,
Please find the attached screenshot for EMP02 & EMP01 Module.
Hi @rahulharjai ,
You are using #E2 Employees: Active ? as a LIST not a subset of #E2 Employees. Please find the screenshot of Pivot view of EMP02 module and observe the difference.
Thank you Jitendra !
Your so close!
Unfortunately, we can't give direct answers on the certifications but let me try to point you in the right direction.
In your SYS08 module, you need to check the format of your department line item.
Remember, ITEM(department) results in a list formatted line item for department. Parent(item(department)) will give you a list formatted line item of the list that is above department.
Experiment with different formulas and/or formats to get it right.
The error you're getting is your best clue.