A Number is required here 1

[Rachel30]

Hi,

I have a formula like

If({spQuoteCG;1.AssCount}) > 0 Then {spQuoteCG;1.AssCount} Else "None"

I am saying if the field in my Stored procedure is > 0 Then display the number other say None.

When I close the formula I am getting a number is required here.

Surley I have have a fromula like this I am using crystal XI.

Cheers Rachel

 

[Madawc]

Try If {spQuoteCG;1.AssCount} > 0 Then ToText({spQuoteCG;1.AssCount}) Else "None"

Crystal doesn't like mixing numerics and text; that's probably the problem.



Madawc Williams (East Anglia, UK)