4 Replies Latest reply on Sep 20, 2012 5:25 AM by Shawn Wallwork

    case statement : converting value

    Amoryn Saayman

      i have a case statement where I need to convert one value to a %. ho can I convert the nominal value to a % for only one of the when statements?


      case [Company Performance]

      when 'Revenue' then [Actual_ Total Revenue]

      when  'EBITDA' then [Actual_ EBITDA Margin % (excl# BLI)] *100

      when 'Measured Cash Flow' then [Actual_ Measured Cash Flow (matched to Bonus calc#)]




      where will i use FORMAT_STRING="Percent"?