5 Replies Latest reply on Oct 12, 2017 8:17 AM by Francesca Grisanti

    Difference between 2 Columns

    Keerthi KS

      Dear All,

       

      Kindly help me with calculating the difference between two Columns.

       

      Below is the calculated field used.

       

      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

       

      This is the output. I need the difference between Confirmed and Cancelled

      MonthConfirmedCancelledDifference
      Grand Total125.198.53116.66
      April36.782.7734.01
      May31.4331.43
      June47.385.7641.62
      July9.609.60

       

      Regards,

      Keerthi KS