where #RTotalEssl value = 0
and @Shared Essl = -2197.70
and @shared essl deletes = 0
I am getting a value of zero. Yet when i bring each number into the report to see what the values are, they are as listed above. total should be -2197.70 I am going crazy with this one.
It should be working and it should not be that difficult!
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 08 Nov 2019 at 10:36am
I always break a formula that is not working into pieces...like one for the running total and one for the shared variable. See if they are working as expected.
Hi! Thanks for your reply! The issue has been resolved. I was adding a negative to a zero and didn't realize that adding a negative to a null or zero, it is still null. So i learned something Have a great weekend!
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