String Error in formula

[ncchish]

I'm using CR 11. I have a formula:

//@QTRVAR

If {@QPlan} = 0 Then
0
Else
(({@QTD}-{@QPlan})/{@QPlan}) * 100

Then I have another formua that evaluates @QTRVAR

//@QTRVAR2

if {@QtrVar} > 999 then "NM" else {@QtrVAR}

I get 'string required here for the second formula. I need to display NM if QTRVAR is > 999. Any ideas?

Thanks.

 

[CR85user]

Both results of an if then else statement must be of the same datatype (For example both numeric or strings).

As a short term solution a simple fix would be:

if {@QtrVar} > 999 then "NM" else totext({@QtrVAR})

If this value is needed at a later point then you can either refer to the original value or use an alternative formula to adjust on the basis of value only.

'J

 

[ncchish]

Thanks! That worked.