a number, or currency amount is required here

[Jeffcis]

Hi,

The below formula has no errors found but when I save it, an error pops up,i,e a number, or currency amount is required here.

if {Sheet1_.Net value} >=0
then Cstr ({Sheet1_.Net value}-{Sheet1_.Condition value},2,'')

The error formula is shown below:
if {Sheet1_.Invoiced Quantity} <> 0
then {@subtotal} / {Sheet1_.Invoiced Quantity}
else 0

then this {@subtotal} is HIGHLIGHTED in BLUE

Appreciate any help.
Jeffcis

 

[dgillz]

Both the if and else values must be the same data type. So do not convert the answer to a string.

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

http://www.gainfocus.biz

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