10 Replies Latest reply on Jan 28, 2019 4:43 AM by Zhouyi Zhang

    Calculation field

    Vinoth kumar T S

      Hi Team,

      My calculation field is not working or may be its taking values as string or whats the problem i cant understand. Here my sheet

      My profit calculation field formula is

      IF SUM([Credit])<0 THEN SUM([Credit]) ELSE SUM([Credit])- SUM([Net Rate]) END

      My data source for this calculation is

          

      typeorder idSkuReal QtySale AmountDebitCreditPurchase
      Shipping Services408-1726334-2976336 -76.7-76.7
      Order408-1726334-2976336VN2H0022_P21325-20.5304.5165
      Refund408-1726334-2976336VN2H0022_P2-1-32520.5-304.5165

       

      Please solve my issue.

      Thanks,

      Vino.