@ChrisHeathcote yes sure. Please find the respective screenshots.
Role should be a dimension of the drivers not additional line items.
Remove the line items which refer to roles.
However, I can see that the drivers module does contain the correct dimensions.
Now check that the line items in the Employee systems module used in the LOOKUPs is populated.
This I believe is also updated via an import.
@ChrisHeathcote Have corrected line items in drivers module please check also sent ss of sys08 module
The Role line item is not populated in you system module.
Update this and the formulas should work.
I have checked again the role line item is populated in sys08 module on the 10th line you can see,Iam not getting where do I have to update.
One of your previous posts contained a picture of the SYS08 module grid view.
The Role line item was blank.
I believe this is the reason no values are coming through as the mapping lookup this line item does not have a value/list item to reference.
Update the contents of this Role line item and the formula should generate values.
View solution in original post
Thanks , now data is populating👍.The content of role item were not updated so it was not populating .
It is great news that the data is now successfully coming through.
If you feel my reply helped solve your query can you please mark it as the solution and Kudo the replies that resulted in the final answer.