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


      Please solve my issue.