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





      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