Working formulas with null records

[smibarb]

I have a formula that, if the Count is null (no records) the formula should regard this as zero. If the count is not Null then the formula should use the count value.

I would like to use:

if IsNull (Count ({rslt_qc_t.rslt_type_id}))then "0" else Count ({rslt_qc_t.rslt_type_id})

however, the formula wants a string after else. How can I do this?

 

[synapsevampire]

Try:

if IsNull (Count ({rslt_qc_t.rslt_type_id}))then 0 else Count ({rslt_qc_t.rslt_type_id})

Enclosing it in quotes in the first section stated that it was a string and you have to have the same data types in the IF and ELSE (no polymorphism here...).

-k

 

[lbass]

Remove the quotes from around the zero. Also I'm betting that you really wanted this at a group level, in which case you need to add the group field as a condition within the count, as in:

if IsNull (Count({rslt_qc_t.rslt_type_id},{table.groupfield}))then 0 else Count ({rslt_qc_t.rslt_type_id},{table.groupfield})

I think that:

count({rslt_qc_t.rslt_type_id},{table.groupfield})

...might have worked just as well though.

-LB

 

[smibarb]

Thank you both.