Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please advise,
I have tried this but it appears to only count the second item.
Count({<[Column A]={'Open'},[Column A]={'Eff-Check'}>} [Column A])
also looking to solve, Count if Column B does not contain 13 where 13 is part of a string ( Like this 13OKabcedf, or 13NOKasdver)
Just list the values separated by commas: Count({<[Column A]={'Open','Eff-Check'}>} [Column A])
And with the second condition for Column B: Count({<[Column A]={'Open','Eff-Check'}, [Column B] -= {"13*"} >} [Column A])
Just list the values separated by commas: Count({<[Column A]={'Open','Eff-Check'}>} [Column A])
And with the second condition for Column B: Count({<[Column A]={'Open','Eff-Check'}, [Column B] -= {"13*"} >} [Column A])