-
1. Re: How to hide ID with different values
Chris McClellanAug 13, 2019 12:39 AM (in response to AnnaMaria AnnaMaria)
1 of 1 people found this helpfulSomething like this ? (I didn't type in the entire ID# )
I did this:
if {fixed [ID] : count(if [Category] = "SCRAP" then 1 end)} = 1
then "REMOVE"
else "KEEP"
end
-
2. Re: How to hide ID with different values
AnnaMaria AnnaMaria Aug 13, 2019 3:21 AM (in response to Chris McClellan)It looks really good but unfortunately it shows all values as "KEEP".
I define "Category" also with the help of calculated field - might it be the reason why it doesn´t work for me?
Nevertheless, thank you for the answer.
-
3. Re: How to hide ID with different values
Chris McClellanAug 13, 2019 3:23 AM (in response to AnnaMaria AnnaMaria)
Can you provide screenshots or something to show what you've done ?
I've shown that it works, so it must be something in your workbook that isn't working properly.
-
4. Re: How to hide ID with different values
Subodh Gupta Aug 13, 2019 4:37 AM (in response to AnnaMaria AnnaMaria)I believe if you modify the calc provided by Chris McClellan slightly, it should work.
if {fixed [ID] : SUM(if [Category] = "SCRAP" then 1 else 0 end)} = 1
then "REMOVE"
else "KEEP"
end
-
5. Re: How to hide ID with different values
Chris McClellanAug 13, 2019 1:39 PM (in response to Subodh Gupta)
Why does my calculation NOT work though ? Yes, you can SUM a 1 or 0, that will work perfectly BUT COUNTing the 1's will also work - the screenshot shows that it works.
-
6. Re: How to hide ID with different values
Subodh Gupta Aug 13, 2019 2:38 PM (in response to Chris McClellan)I apologize, I didn't mean to imply it won't work. I could have definitely worded my response better.
-
7. Re: How to hide ID with different values
AnnaMaria AnnaMaria Aug 14, 2019 3:42 AM (in response to Chris McClellan)Hey! Thaanks for the help i`ve found my mistake)