Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have this expression which (technically) gives me the correct value I need.
if(match(Aggr($(vStarWeight),Star,MeasureID,Region_DESC),1),$(vStar2),null())
However, there are certain instances where I would need this value to show as negative. Or even simply with a '-' in front of the number. For example, if(match(MeasureID,'CDC2_HBAPOOR','PartD_HRM','PCR2') is when I would need the expression to show as negative.
How can I modify this expression to show either a '-' or a negative number value for those MeasureIDs ('CDC2_HBAPOOR','PartD_HRM','PCR2')?
Any help is appreciated!
Hi,
maybe this is a possible solution:
if(match(MeasureID,'CDC2_HBAPOOR','PartD_HRM','PCR2'),
if(match(Aggr($(vStarWeight),Star,MeasureID,Region_DESC),1),$(vStar2) * -1,null()),
if(match(Aggr($(vStarWeight),Star,MeasureID,Region_DESC),1),$(vStar2),null())
)
Please let me know if this helps.
Kind regards,
Please try:
if(match(Aggr($(vStarWeight),Star,MeasureID,Region_DESC),1),
if ([MeasureID] = 'CDC2_HBAPOOR' or 'PartD_HRM' or 'PCR2', $(vStar2)*-1, $(vStar2) ),
null()
)