1 Reply Latest reply on Mar 5, 2012 2:26 PM by philmodjunk

    Calculation based on condition of another field

    Lantonicus

      Title

      Calculation based on condition of another field

      Post

      Hello All,

      I am developing a budget layout. I need to take sum of 3 values based on some condition

      Here I created some fields, these are as follow:

      Cashamount

      DebitAmount

      Credit Card amount

       

      I also have 2 field defining the type of transaction

      Field :  DebitCardTransaction Type  >> contains Value List : (  CashAdvance , Purchase)

      Field : CreditCardTransaction Type  >> contains Value list : ( CashAdvance , Purchase)

       

      I am trying to make a sum calculation that based on condition:

      Total = CashAmount  + CreditCard + Debit Card

      the problem I face is that  

      I want  to include  All cashmounts,  All Credit Card amounts ( BOTH CreditCard Transaction Type: Cashadvance AND Purchase )  BUT Debitcard amount(for DebitCard Transaction Type: Include Purchase EXCLUDE CASHADVANCE)

      I am kind of new to calculation functions. I could not figure out which functions I could use (get?, Evaluate?, IF? , Case?) 

       

      I hope that I could explain what I want to achieve in a clear way so that somebody can recommend me a calculation formula.

      example

      Regards