2 Replies Latest reply on Oct 26, 2013 12:36 PM by Ramon Martinez

    How do I create a calculation based on the value of a cell?

    brian.kim.0

      In my viz of personal spend, I am trying to make what I think is a calculated field that subtracts the amount if a corresponding cell value is 'Credit'

       

      Here is basically what I have

       

      DateDescriptionOriginal DescriptionAmountTransaction TypeCategoryAccount NameLabel
      10/20Food @ TargetMilk5.00DebitGroceriesCash
      10/21Return @ WalmartOJ3.00CreditGroceriesCredit

       

       

      So basically, if the Transaction Type of a row is equal to 'Credit' then I want my running sum to subtract the value in the Amount column. In this example, the Net Sum would be a total of 2.00 (5-3=2)

      I tried this following formula, but it hasn't done anything:

       

      If [Transaction Type] = "Credit" then Amount  * -1

      END

       

      Any help would be greatly appreciated