concatenation in set analysis

[#1]

Hi

I have a calculation, as below - which is failing:

=if (

  sum( <  NPSYear &' '& NPSQuarter  =  {'2016 Q3'} >} [Score])

  <11 ,  argb(150, 255,0,0), argb(150, 0,128,0) )

I assume it is the ampersand ?

I have tried putting  NPSYear &' '& NPSQuarter into a variable - vQtr, and using it here, but no luck.  Any ideas!

Cheers

Andrew

[sunny_talwar · Accepted solution]

Left hand side of a set modifier cannot be a function or calculation.... try like this may be?

=If(Sum(<NPSYear = {2016}, NPSQuarter = {'Q3'}>} [Score]) <11, ARGB(150, 255,0,0), ARGB(150, 0,128,0))

[#3]

it can't?  Well that's good information! Many thanks

[sunny_talwar]

Yes, left hand side needs to be a field which is derived in the script. No calculations or functions are allowed on the left hand side