Sets with multiple fields in the condition using variable

[shyamcharan]

Hi Experts,

How can I include multiple fields in the sets using the variable?

I am trying the below but it is not working.

Sum({<$(vStaffOfficerfields)>}ResponseMin)/Sum({<$(vStaffOfficerfields)>}ResponseCase)

vStaffOfficerfields = 'InternalStaff,ExternalStaff,Contractors,Executives,NonExecutives,OutsideStaff'

InternalStaff,ExternalStaff,Contractors,Executives,NonExecutives,OutsideStaff are fields with different staff names.

I am trying to create a summary value to ignore all the selections made on these staff fields. However, since the number of fields are more, i am trying to put them in a variable and call them through the variable for easy maintenance.

Can anyone suggest how can I get this correct?

Thanks in advance.

Regards,

Shyam.

[Anonymous]

Try add "Total" after sum (total.

[settu_periasamy · Accepted solution]

Hi,

try to remove the single quote and check it. It will show the error line, just ignore it..

[shyamcharan]

Thanks settu.