Formula for multi conditions

[Bostjan Ahacic]

Count

 

%

Final result

 

 

14

95%

HIT

 

 

7

85%

Exclude

 

 

35

120%

MISS

 

 

37

85%

MISS

 

 

42

100%

HIT

 

 

 

Hi,

How to write formula in "Edit Calculation Column" for "Final resut" field:

if "Count" is >25 and "%" >90 and 25 and "%" 110, then "Final result" is "Exclude"

 

Thank you,

Bostjan

[Kirsten Smith (she/her)]

Something like:

 

case when [Count] >25 and [%] >90 and [%] 25 and [%] 110 then "Exclude" end

as [Final Result]

[Bostjan Ahacic]

Hi, sorry but this doesn't work.This one works but not 100%. It doesn't work when "Count" is <25 and "%" is lower than 90% or higer than 110%.case [Final result]

when "HIT" then "HIT"

when "MISS" then If([Count WO]>24,"MISS")

else "Exclude"

END

[Bostjan Ahacic]

Hi,but this on works:case 

when [Final result]="HIT" then "HIT"

WHEN ([Final result]="MISS") and ([Count WO]<25) then "Exclude"

ELSE "MISS"

END

[Gaia Paolini]

Hi

I need a clarificationon the desired logic. See below.

Thanks

Gaia

 

 

if "Count" is >25 and "%" >90 and 90 and % < 110 but missing case for Count=25

 

if "Count" is>25 and "%" 110, then "Final result" is "MISS"

if "Count" is>25 and "%" 110, then "Final result" is "Exclude"

From these and from the examples, it is not possible to work out the final result.

In both lines Count>25, so there is no case for Count

[Bostjan Ahacic]

Hi,this my logic works:case 

when [Final result]="HIT" then "HIT"

when ([Final result]="MISS") and ([Count WO]<25) then "Exclude"

else "MISS"

endThank you on answer. 

[Gaia Paolini]

Hi

 

if you are happy with it, that is great.

 

Gaia