If running total is zero, and Shared Essl field is negative, it will not display as negative. If there is a value> 0 in running total, then i will get a negative number for the total.
example: 0 + -1297 = 0
480 + -1297 = -817
How do I get the total to be a negative if my running total is a zero ?
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 05 Nov 2019 at 10:18am
Actually it appears that your running total may be returning a null, since a Null + anything would still be basically Null. Check your formula and see if it using 'Default Values for Nulls' (good to be using anyhow).
If it is not that, then I am not sure what is going on.
Thank you so much! Actually I did figure this out before I saw your post, but I appreciate the reply! Didn't realize that zero was treated differently. so i learned something new today!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
