1 Reply Latest reply on Dec 13, 2013 12:22 PM by Andrew Ball

    Sum with a condition : How to calculate 2 fields on a condition that both ARE NOT negative.

    andreia silva

      Hi ,

       

      can some one advice on how I can calculate two fields with a condition where both are not not negative ?  as when current formula finds two negative it is giving me positive number

      thanks,

       

      e.g

       

      GP    Cost

      -100     -100

      200       -50

       

      1st scenario :

      formula will only count second row  (sum =150)

       

      2nd scenario :

       

      formula to not give a positive value for row 1 , so result of sum for row one is -200 and for row 2 is 150

       

      Thanks

      Deia