Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I’d like to know how to make this output in this table taking those booleans into account for making the restriction condition.
If boolean is 0 in any row this code has to be discarded.
The logic explained is similar to this: [1,1,1,1] & [1,1,0,0] & [1,1,1,0] & [6656, 6657, 6658, 6659] = [6656, 6657, 0, 0]
Table;
Desired output;
Tried with If(sum(aggr(sum(aggr(sum(Boolean),Code,Category)),Category))=sum(aggr(sum(aggr(max(sum(Boolean)),Code,Category)),Category)),1,0)
Borja, in these cases, it generally helps get responses if you can attach the app or a sample app with the issue, so folks can look at things in much greater detail.
Regards,
Brett