Formula will not add 0 value to negative value
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22831
Printed Date: 25 Apr 2024 at 2:46pm
Topic: Formula will not add 0 value to negative value
Posted By: Kitty1
Subject: Formula will not add 0 value to negative value
Date 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 ? |
Replies:
Posted By: kevlray
Date 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.
|
Posted By: Kitty1
Date 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! 
|