Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to do a complex set analisys in my count function, but as you can see in attachment - Count works wrong with the complex set analisys, while Concat works perfect.
How this issue can be solved? Or maybe I have mistakes in my Set Analisys?
Try without using distinct in count function... But don't ask me why.
I need it to be distinct 😞 for now I have a solution:
=SubStringCount(concat({$<F1={">=2"}>*($<F2={1}>+$<F3={1}>)} distinct F1,'-'),'-')+rangemin(1,len(concat({$<F1={">=2"}>*($<F2={1}>+$<F3={1}>)} distinct F1,'-')))
Going back to your firsts expressions, did you try to make a table? If you put the expression ant then one, two or the three dimensions (F1,F2,F3), the count function works as it should. However, if you leave the table without dimensions it works wrong... ![]()
What we are missing must be something stupid...
Try the following formula. It seemed to work for me in you example file.
count({$<F1={">=2"} * (P({1<F2={1}>}) + P({1<F3={1}>}))>} distinct F1)
Regards.