Community & Support
Learn
Marketplace
Discussions
Categories
Discussions
- General
- Platform
- Academic
- Partner
- Regional
User Groups
Documentation
Events
Altair Exchange
- Share or Download Projects
Resources
Employee Resources
- This tab can be seen by employees only. Please do not share these resources externally.
Groups
- Join a User Group
Support

Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Home
Discussions
Community Q&A

[SOLVED] Nesting expressions

How do you nest IF-THEN-ELSE statements in a function expression?

I tried the following but get a syntax error.

if(BALANCE==0,"NONE",if(BALANCE<=-100,"HIGH",IF(BALANCE>0,"OVERPAYER","UNKNOWN")))

Error: Encountered " ", " ", "" at line 1, column 58. Was expecting one of: ">" ... "" ... "==" ....... etc etc.

Trying to do this in a Generate Attribute to create labels.

RapidMiner 6.0.0.001.

Find more posts tagged with

AI Studio

Accepted answers

All comments

Andrew2

Hello Ted

It might be the uppercase IF - change it to lower case.

regards

Andrew

tmanasa

Thanks, Andrew. You were right about the capital "if". This works.

if(BALANCE==0,"FULLPAYER",if(BALANCE<0,"OVERPAYER",if(BALANCE>0,"UNDERPAYER","UNKNOWN")))

Quick Links

All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups