Help with Formula Tool - Malformed If Statement

[lisamccullough]

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!

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

[atcodedog05 · Accepted solution]

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 😀👍

[vizAlter]

@lisamccullough — Take a look at below:

Now, the data type is double so you should use Null() instead of a space " " in the formula.

[atcodedog05]

Happy to help 🙂 @lisamccullough 

Cheers and Happy Analyzing 😀