INVALID TYPE in OPERATOR

[peter987]

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.

[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.

[peter987 · Accepted solution]

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

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

[andyuttley]

Hi @peter987 

Your formula is legit, but it may be because the field you're creating isn't a string field, but you're trying to write and output such as "PAY". Assuming you're creating a new field, you'll want to make sure it is a string to allow that kind of result, such as this (note the highlighted part):

Hope that helps

thanks

Andy 

[andyuttley]

---

@peter987 wrote:

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

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

---

That implies that the Total FV field is not numeric; it's probably worth making sure it's numeric if you're wanting to use > or < functions, to ensure you always get the results you expect downstream! 

[peter987]

Thank you ever so, Andy!

Hope this helps other users too cause I couldn't get the hang of it for ages:)

[andyuttley]

No problem 🙂