Skip to main content
Nintex Community Menu Bar
Solved

Sum(Above) function not working when there are negative values

  • July 29, 2024
  • 2 replies
  • 62 views

Forum|alt.badge.img+1

I have a grouped table of data and I want to sum up the values above - so I’m using the sum(Above) function.

This works great until I have negative values in the merge fields - and it ignores them.

Any thoughts of a work around or a different function to use?

 

Best answer by wenorp

Update - figured out that the document creation doesn’t calculate the sum(above) function correctly but if you update the field manually - it seems to work.

2 replies

Forum|alt.badge.img+1
  • Author
  • Novice
  • July 29, 2024

Just to confirm this is in a Word document.


Forum|alt.badge.img+1
  • Author
  • Novice
  • Answer
  • July 30, 2024

Update - figured out that the document creation doesn’t calculate the sum(above) function correctly but if you update the field manually - it seems to work.