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