Absolute value of year value

I would like to sum an absolute value of a monthly line item. Might for example have values -2 i january, -3 i february and +5 in March. Would like a line that calculates the absolute yearvalue of this as 2+3+5=10 (not -2-3+5 = 0)

Best Answer

  • Create another line item for absolute value and put formula there ABS(Value). Reference this new line item to your Yearvalue formula.

    Hope this helps!