2 of 2 people found this helpful
The primary reason you're getting those lines and gaps is because your data includes 0's. One approach to fix the problem would be to create a new calc for Net Value that excludes 0's. It would look like this:
If Sum([Net Value]) > 0 Then Sum([Net Value])
ELSEIF Sum([Net Value]) < 0 Then Sum([Net Value])
You'll see that there are still a couple of small gaps, which I'm not entirely sure why they are present but I'll let you know if I can find a remedy.
Thank you, Wesley!
I created the calc field, and the lines were removed, but there were still gaps, as you mentioned. BUT... it also gave me an alert of NULLS present in my data. When I clicked on the alert and selected "Show Data At Default Position," it removed the gaps as well.
This got me exactly the result that I was looking for.