2 Replies Latest reply: Aug 30, 2016 6:52 PM by Haikuo Yu RSS

    Show result as a negative value

    Linda Pembroke

      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!