Absolute value of year value

samdal

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)

umangsinghal

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!

samdal

Thanks, simple and effective solution!

umangsinghal

You're welcome! Please accept the answer as well.