?

[xyz1]

.

[sunny_talwar]

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?

[xyz1]

.

[xyz1]

.

[sunny_talwar]

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

[xyz1]

.

[sunny_talwar]

Can you reload the attached application for me

[xyz1]

.

[sunny_talwar]

Will check it in a bit. Incorrect numbers is okay

[xyz1]

.

[sunny_talwar]

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