Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am counting how many cells contain > 80% but also want to exclude any that contain 100%. This is what I have which works but I have to add the fact of not counting the 100% in that set of data.
Count({<[UMHC SYSTEM]={'>0.8'},[EC-LS-EM]= {'EC'}>} [UMHC SYSTEM])/16
Thanks for your help in advance!
May be this
Count({<[UMHC SYSTEM]={">0.8<1"}, [EC-LS-EM]= {'EC'}>} [UMHC SYSTEM])/16
May be this
Count({<[UMHC SYSTEM]={">0.8<1"}, [EC-LS-EM]= {'EC'}>} [UMHC SYSTEM])/16
Well, that was a dumb mistake! LOL
Thanks Sunny!