A number is required Here 2

[Jeffcis]

Hi,

Im getting error on my formula "A number is required here"

Formula: if {Sheet1_.ZFR1 - Airbag}>0
then sum ({Sheet1_.ZFR1 - Airbag}, {Sheet1_.Bill#Doc#})
else ""

I'm trying to show if {Sheet1_.ZFR1 - Airbag}>0
then sum ({Sheet1_.ZFR1 - Airbag}, {Sheet1_.Bill#Doc#})
else show {Sheet1_.ZFR1 - Airbag} as blank

Appreciate any help

Thanks,
Jeffcis

 

[jdemmi]

Where is the cursor placed when the error is displayed? (This indicates where the number is expected)

I am just guessing here (a little) that it's being placed after the "else"

try this...

if {Sheet1_.ZFR1 - Airbag}>0
then cstr(sum ({Sheet1_.ZFR1 - Airbag}, {Sheet1_.Bill#Doc#}))
else ""

-- Jason
"It's Just Ones and Zeros

 

[dgillz]

Both the then and else values must be the same datatype, hence the error. I would try this:

if {Sheet1_.ZFR1 - Airbag}>0 then 
sum ({Sheet1_.ZFR1 - Airbag}, {Sheet1_.Bill#Doc#})
else 0

If you don't want to see the zero, format the formula to suppress if zero.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?