12 Replies Latest reply on Oct 16, 2017 3:22 AM by Jayshree Dawrewar

    Negative Values

    Keerthi KS

      Dear All,

       

      I have an Calculated field like something below. I need to show Cancelled in Negative Values. Can someone help me with this.

       

      Tried multiplying CancelledSaleValue with -1(- [CancelledSaleValue]) but its not showing.

       

       

      Case [SalesViewBy]

      When "Gross" then Sum(

      If [Order Status (group)]='Confirmed' then [Sale Value]

      ELSEIF [OrderStatus]='Cancelled' then [CancelledSaleValue]

      END)/10000000

      When "Unit" then

      Countd(

      If [Order Status (group)]='Confirmed' then [Unit ID]

      ELSEIF [OrderStatus]='Cancelled' then [CancelUnitID]

      END)

      When "Area" then Sum(

      If [Order Status (group)]='Confirmed' then [Saleable Area]

      ELSEIF [OrderStatus]='Cancelled' then [CancelSaleableArea]

      END)

      END

       

      Regards,

      Keerthi KS