INVALID TYPE in OPERATOR

Hi,

I'm trying to create a simple condition: IF [Total FV]>0 THEN "REC" ELSE "PAY" ENDIF

But I keep on receiving INVALID TYPE in OPERATOR.....there's a problem with > operator

I tried to put "" before/after "[Total FV]>0"....then the error message disappeared but the results were rubbish as Total FV was assigned only "PAY".

Thanks for any advice.

Error Message

Accepted answers

peter987

sorry, I just found there should be "" before/after 0....now it works perfectly:)

IF [Total FV]>"0" THEN "REC" ELSE "PAY" ENDIF

All comments

benakesh

Hi @peter987 ,

Add a select before formula or check metadata for [Total FV] data type .

The error may be because [Total FV] is not numeric.

peter987

Thanks,Benakesh

the thing is that Total FV is numeric...just wanna make simple condition if Total FV (fair value) is > 0 then it is REC (receivable) if not it is PAY (Payable)

I checked that data format of Total FV is V_WString so it should be set as numeric.

Thanks a lot.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335