3 Replies Latest reply on May 9, 2017 2:31 AM by Bernd Alheit

    Simplified Notation Calculation

    bethr46632610

      I am fairly new at Adobe Calculations.  I am trying to write a calculation where the calculation would look like this Field = A - (B+C+D+E+F+G+H).  12 additions total, representing on number for each month.  When I write it like this it won't work but when I flip the calculation order around it does but it results in a negative number when I want a positive.

       

      This calculation does not work.

       

      ANNUALTOTALRow1 - (JANRow1 + FEDRow1 + MARRow1 + APRRow1 + MAYRow1 + JUNRow1 + JULRow1 + AUGRow1 + SEPRow1 + OCTRow1 + NOVRow1 + DECRow1)

       

      This one does.

       

      (JANRow1 + FEDRow1 + MARRow1 + APRRow1 + MAYRow1 + JUNRow1 + JULRow1 + AUGRow1 + SEPRow1 + OCTRow1 + NOVRow1 + DECRow1)-ANNUALTOTALRow1