Need to utilize data within summary field

[Goalie3533]

Hi guys.

I'm writing a formula that needs to check whether the value of a summary field is null or not(ok, I'm still rather new to crystal so just to make sure I'm calling this field by its propper name, when I right click on the field, the top line reads "Field: Sum of B4DS.CreditAmount". So I'm just assumming this is a summary field.)

So, I've tried "if" statements within my formula to check for this such as:
-----------------------------------------------
"if isnull({Sum of B4DS.CreditAmount}) then"
-and-
"if (isnull({Sum of B4DS.CreditAmount})) then"
------------------------------------------------
I had no luck however.
I also tried creating a "sum" of the "creditamount" field by using:
-----------------------------------------------------
"if isnull(sum{B4DS.CreditAmount})) then"
-----------------------------------------------------
but again, I received an error.
Any idea on how I can find out if this field is blank or not?

Thanks in advance.

-Goalie35

 

[lbass]

Try:

if isnull(sum({B4DS.CreditAmount},{table.group})) then//rest of formula

...where {table.group} is your group field. I'm assuming you are evaluating whether the sum is null for some group. If you really mean to evaluate this sum at the grand total level, then eliminate ", {table.group}".

-LB