?
Solved

Show zero if field is blank - CR 8.5 - urgent

Posted on 2009-12-23
2
Medium Priority
?
360 Views
Last Modified: 2012-05-08
Hi- Why can't I get this to work? I have been trying all day and still can't figure it out. I have several like this, in fact, so I am seriously missing something.
Can anyone help me so I can get out of here before the blizzard starts???

if Sum ({BBCHGLIN.EXTPRICE}, {BBJTHEAD.LJOB}) = "" then "0" else Sum ({BBCHGLIN.EXTPRICE}, {BBJTHEAD.LJOB})

It asks for a number after the = sign. If I put a number in, it then asks for a string after the else.
Thanks, Megan

0
Comment
Question by:wgraphics
2 Comments
 
LVL 4

Accepted Solution

by:
ravenblue earned 2000 total points
ID: 26115872
try

if isnull(Sum ({BBCHGLIN.EXTPRICE}, {BBJTHEAD.LJOB})) then 0 else Sum ({BBCHGLIN.EXTPRICE}, {BBJTHEAD.LJOB})
0
 

Author Closing Comment

by:wgraphics
ID: 31669616
You are so awesome
THANK YOU!!!!
Megan
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question