Help with Formula Tool - Malformed If Statement

Hello - I'm hoping someone can help me with this formula that I'm trying to enter. I keep getting a Parse Error:

IF [% Total Assets]>=1
OR
IF [% Total Assets]<=5
THEN "Y" ELSE " " ENDIF

It appears the "ENDIF" is the problem because it's underline in red. Not sure what I'm doing wrong. Thank you in advance for all the help you provide or have provided. I appreciate it!

Workflow

Input

Tips and Tricks

Parse

Accepted answers

atcodedog05

Hi @lisamccullough

yes should be double. Either you can use select tool to convert [% Total Assets] to double or you use can below formula to convert during calculation itself.

IF ToNumber([% Total Assets])>=1 OR ToNumber([% Total  Assets])<=5 THEN "Y"
ELSE " " ENDIF

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

All comments

RolandSchubert

Hi @lisamccullough ,

I think, only a small modification is needed:

Try:

IF [% Total Assets]>=1 OR [% Total Assets]<=5 THEN

"Y"

ELSE

" "

ENDIF

Let me know if it works for you.

Brest,

Roland

vizAlter

@lisamccullough — not sure why you are using a space char " " in the formula.

Hope, this will be helpful:

lisamccullough

I failed to mention that the %Total Asset data type is V-String. Should it be a Double? I ask because I'm still unable to get this formula to work. Or how can I change my formula to double?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703