Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: How to return Zero if No records in Running Total Post Reply Post New Topic
Author Message
theitvideos
Newbie
Newbie
Avatar

Joined: 15 Feb 2011
Location: Australia
Online Status: Offline
Posts: 5
Quote theitvideos Replybullet Topic: How to return Zero if No records in Running Total
     Posted: 16 Mar 2011 at 3:24pm
Hi there,

I am working on a Crystal Reports using Running Total. If the total return null or nothing, I want the value to appear as 0

Currently when there are no values to calculate, it returns blank.

How can I check if the Running total value is Null and if it is, just return zero.

Kindly reply.

Thank you :)
IP IP Logged
theitvideos
Newbie
Newbie
Avatar

Joined: 15 Feb 2011
Location: Australia
Online Status: Offline
Posts: 5
Quote theitvideos Replybullet Posted: 16 Mar 2011 at 5:36pm
anyone please reply...
IP IP Logged
Rufus
Newbie
Newbie


Joined: 12 Apr 2011
Location: United States
Online Status: Offline
Posts: 2
Quote Rufus Replybullet Posted: 12 Apr 2011 at 7:58am
Try using this in a formula
 
if not isnull({#Breaker Price}) then {#Breaker Price} else 0
 
This will basically use the {#Breaker Price} value if it is not null or 0 if it is null
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.