[DrewAllen]

Quote:

Originally Posted by Melissa Siobhan

LOL Drew. You are too funny. To those of us just catching on to crystal it took me aa while to read this response but I finally get it.

Can the report be programmed to have a use a default for null as $0? would that make the expression above work properly?

If not, Roesing, can you maybe explain what you want in more plain english for me because it sounds like you need to completely reformulate this expression (and deal with nulls)

It's so much easier to explain this with pictures (flowcharts).

You can go into the Report Options and set the "Convert Null Values to Default". It sounds like Roesing has done this.

In Crystal XI, you can set this option just for the one formula. I actually prefer keeping the null values in most cases, particularly when dealing with amounts. Sometimes it helps to distinguish between a null value and a $0 value.

In Crystal 8.5, you can use IF...THEN...ELSE and IsNull() and either store the result in a variable or create a sub-formula which you can then use in your main formula.

Drew