Something missing in formaula

Kamran1991

if [Fun Score]<1 then "LIFE CHANGING!" elseif
if [Fun Score]>1 then "AMAZING" elseif
if [Fun Score]>2 then "Great!" elseif
if [Fun Score]>3 then "Fun" elseif
if [Fun Score]>4 then "Pretty Good" elseif
if [Fun Score]>5 then "Feeling Weird" elseif
if [Fun Score]>6 then "Dizzy" elseif
if [Fun Score]>7 then "Sick" elseif
if [Fun Score]>8 then "Really Sick" else
"Refund" endif

Can anyone let me know what is wrong in this formula ?

Thanks,

Kamran

Tips and Tricks

Accepted answers

All comments

ShankerV

Hi @Kamran1991

Could you please remove the extra if added after each ELSEIF.

Many thanks

Shanker V

ShankerV

Hi @Kamran1991

The below will work for you.

if [Fun Score]<1 then "LIFE CHANGING!"

elseif [Fun Score]>1 then "AMAZING"

elseif [Fun Score]>2 then "Great!"

elseif [Fun Score]>3 then "Fun"

elseif [Fun Score]>4 then "Pretty Good"

elseif [Fun Score]>5 then "Feeling Weird"

elseif [Fun Score]>6 then "Dizzy"

elseif [Fun Score]>7 then "Sick"

elseif [Fun Score]>8 then "Really Sick"

else "Refund"

endif

Note: Make sure the column [Fun Score] is of numeric datatype. Else we need to use [Fun Score] > "1", all the values should be within ""

Many thanks

Shanker V

Kamran1991

I have tried all the logics but not working out.

FinnCharlton

@Kamran1991 What error message are you getting? Even better if you could share a sample workflow with us to take a look at.

Kamran1991

Having tried all the logics and applications, I am totally exhausted now therefor shut the task up.

mceleavey

@Kamran1991 ,

as @FinnCharlton requested, can you let us know what's wrong?

The first post simply had an Elseif followed by an IF, which would error. After that was solved, can you let us know what the new error is?

Kamran1991

Error message is attached here,

Thanks,

Kamran

Error message (1).PNG

FinnCharlton

Hi @Kamran1991 , there is still something wrong with your IF statement, have you tried @ShankerV's solution above? If this still doesn't work, please could we see a screenshot of the formula and we should be able to fix it

Rana_Kareem

Hi @Kamran1991 ..

What's the data type of Fun Score?

It must be Double or Float

Rana_Kareem

@Kamran1991..

Another thing I'd add.. you need to change the order of conditions!

Order it descending not ascending.

Because with this expression you'll get only two results "LIFE CHANGING" and "AMAZING" and that's not right

That's because IF Statement will just take the first conditions that are met.

In your case:

IF [Fun Score] < 1 THEN "LIFE CHANGING!"

Will check if the condition is met then it will return the result, no problem with that.

Then, it will check if the following condition is met and will return the result..

ELSEIF [Fun Score] > 1 THEN "AMAZING"

After that it will stop checking, it won’t check this condition:

ELSEIF [Fun Score] > 2 THEN "Great!"

Because the previous condition said if the Score is more than 1 then return ‘AMAZING’ , So, all the following conditions will be ignored, because all the remaining Scores are above 1 !!

To correct your expression, you need to rearrange the conditions to be like this:

IF [Fun Score] >= 9 THEN "Refund"
ELSEIF [Fun Score] >= 8 THEN "Really sick"
ELSEIF [Fun Score] >= 7 THEN "Sick"
ELSEIF [Fun Score] >= 6 THEN "Dizzy"
ELSEIF [Fun Score] >= 5 THEN "Feeling weird"
ELSEIF [Fun Score] >= 4 THEN "Pretty good"
ELSEIF [Fun Score] >= 3 THEN "Fun"
ELSEIF [Fun Score] >= 2 THEN "Great!"
ELSEIF [Fun Score] >= 1 THEN "AMAZING"
ELSEIF [Fun Score] < 1 THEN "LIFE CHANGING!"
ELSE NULL()
ENDIF

Hope that’s clear and helps you..

Quick Links

This months top contributors

mceleavey 383

AkimasaKajitani 382

mbarone 337

Hollingsworth 335

LanisC 335