Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Formula will not add 0 value to negative value Post Reply Post New Topic
Author Message
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Topic: Formula will not add 0 value to negative value
    Posted: 05 Nov 2019 at 8:05am
I have a formula:

{#RTotalEssl} +{@Shared Essl}-{@shared essl deletes}

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 ?
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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.
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 05 Nov 2019 at 10:32am
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!   
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.