If Statement - A number is required here 1

[Jefftopia]

if ({ado.LIB_Spread}/100) > 0 then ({ado.LIB_Spread}/100) else "NA"

I am getting the following error message when I attempt to use this formula in my report:

"A number is required here"

It then places focus on the "else 'NA'" portion of my formula. I have tried a number of things, including converting the statement to a string and checking if the length > 0. Nothing has proved successful.

If statement does not seem to want to allow both an outcome of a number and a string in the same statement.

Anyone?

 

[bdreed35]

Any results from you IF statement have to be the same data type. If you "If" statement is True then you are returning a numeric value. If you "If" statement is false, you are attempting to return a string.

Convert your numeric value to Text using the ToText function or you will need to change the "NA" to a numeric value.

~Brian

 

[MJRBIM]

It's two formulas...

Name : {@YourFormula}
Formula :if ({ado.LIB_Spread}/100) > 0 then ({ado.LIB_Spread}/100) else 0

Name : {@NA}
Formula :if {@YourFormula} = 0 then "NA" else ""

Place both formulas in the same place on your detail and supress blanks on {@NA} and zero-values on {@YourFormula}.

 

[Jefftopia]

MJRBIM,

Something is not working with the first formula. I created 2 formulas exactly as you described above. When I run the report, no result is appearing for the first formula which in turn is making it so the second report contains no result either.

I am thinking the value of {ado.LIB_Spread} may be a null value. That may be the problem. Still working on it.

 

[dgillz]

An easier solution:

if ({ado.LIB_Spread}/100) > 0 then totext(({ado.LIB_Spread}/100)) else "NA"

Since this formula returns text in either the true or false scenarios, it will work.



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

http://www.trianglepartners.com

 

[basil3legs]

if ({ado.LIB_Spread}/100) > 0... ??

Why divide it by 100 then compare it to 0?


Assuming ado.LIB_Spread is a number, try:

if ((NOT ISNULL{ado.LIB_Spread}) and ({ado.LIB_Spread} > 0)) then totext(({ado.LIB_Spread}/100)) else "NA"

If you need to use the result in any calculations, adapt MJRBIM's 2 formulae accordingly.

p.s. you can still divide it by 100 first if you must

 

[Jefftopia]

[Resolved]

Thank you all. I ended-up using basil3legs modified code of dgillz. bdreed35 was also on the right path by pointing me to the ToText function.

problem solved...