formula not matching
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=22830
Printed Date: 20 Apr 2024 at 3:40am
Topic: formula not matching
Posted By: Kitty1
Subject: formula not matching
Date Posted: 04 Nov 2019 at 8:11am
|
Hi,
I have a report which brings in shared variables to main report from subreport. i am doing a simple calculation: {#RTotalEssl}+{@Shared Essl}-{@shared essl deletes} 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! |
Replies:
Posted By: lockwelle
Date 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.
HTH |
Posted By: Kitty1
Date Posted: 08 Nov 2019 at 10:40am
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! 
|