Bostjan Ahacic Posted December 21, 2018 Share Posted December 21, 2018 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 Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted December 21, 2018 Share Posted December 21, 2018 Something like: case when [Count] >25 and [%] >90 and [%] 25 and [%] 110 then "Exclude" end as [Final Result] Link to comment Share on other sites More sharing options...
Bostjan Ahacic Posted December 25, 2018 Author Share Posted December 25, 2018 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 Link to comment Share on other sites More sharing options...
Bostjan Ahacic Posted December 25, 2018 Author Share Posted December 25, 2018 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 Link to comment Share on other sites More sharing options...
Gaia Paolini Posted January 4, 2019 Share Posted January 4, 2019 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 Link to comment Share on other sites More sharing options...
Bostjan Ahacic Posted January 4, 2019 Author Share Posted January 4, 2019 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. Link to comment Share on other sites More sharing options...
Gaia Paolini Posted January 4, 2019 Share Posted January 4, 2019 Hi if you are happy with it, that is great. Gaia Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now