How to Read back from a consolidated module
Hi
Experts!
I have a module A using below dimensions - Sales Territory Quota Mapping list is a list with sequence numbers from P1 to P6000.
there are properties like Employee (using list of EmployeeAssignment) and Employee ID in this module.
And a module B like below, where I consolidated/summed the numbers by EmployeeAssignment (1 employee assignment might have been used in multiple Px list items in Module A)
Now Module B has a Status column, but we want to read back this status column at one employeeassignment to all its Px lines. How can I achieve that? Thanks a lot!
Answers
-
Hi!
Did you try ?Best,
Konstantin
1 -
Hi,
@CommunityMember121571 is correct on advising to use lookup. If you have employee assignment and quota defined for PX items you can simply take. Module B.Value[LOOKUP: Employee Assignment, LOOKUP: Quota] from Model A.
1