Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if(Location='NewYork' ,
if([Score] >=11 ,green(),
if([Score] <=11 ,yellow(),
if([Score] =0,red()))))
Can I use the above expression to assign colors to text objects ?
May be this
If(Only({<Location *= {'NewYork'}>} Location) = 'NewYork',
If(Only({<Location *= {'NewYork'}>}[Score]) = 0, Red(),
If(Only({<Location *= {'NewYork'}>}[Score]) <= 11, Yellow(), Green())))
This will work only if there is only one possible Location and Score are there? If you have more than one option for either of them, it might not work
Ya...I have more locations..How can i resolve that ?
Hi Ansh
plz explain more , let's say we have three locations "New York","London","Beijing"
what color would you like to show when user select more than 1 location , for example "New York"&"London"?
May be this
If(Only({<Location *= {'NewYork'}>} Location) = 'NewYork',
If(Only({<Location *= {'NewYork'}>}[Score]) = 0, Red(),
If(Only({<Location *= {'NewYork'}>}[Score]) <= 11, Yellow(), Green())))