Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
I think since you are doing the calculation in the script, you are loosing the ability to sum team on the front end. Is there a reason you want to do this in the script? Can we move this to the front end?
.
.
Can you make a change like this in your script and rerun it for me?
SubField(ApplyMap('MappingTable1', ROLE, 0), '|', 1) as [REF BUILD1],
ApplyMap('MappingTable2', [Employee Name]&ROLE, 0) as [REF BUILD2],
ApplyMap('MappingTable3', [Employee Name]&Team, 0) as [REF BUILD3],
ApplyMap('MappingTable4', [Employee Name]&Month(Date#(Month, 'MMMM')), 0) as [REF BUILD4],
SubField(ApplyMap('MappingTable1', ROLE, 0), '|', 2) as Enable1,
ApplyMap('MappingTable2', [Employee Name]&ROLE, 0) as Enable2,
ApplyMap('MappingTable3', [Employee Name]&Team, 0) as Enable3,
ApplyMap('MappingTable4', [Employee Name]&Month(Date#(Month, 'MMMM')), 0) as Enable4,
Essentially create a new field instead of multiplying them into 1. Do it for Enable, REF BUILD and Run
.
Can you reload the attached application for me
.
Will check it in a bit. Incorrect numbers is okay
.
Its complex... I am looking at it while doing my own work... not sure if I will get to the bottom of it, but I am trying