Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Terratorterry
Contributor
Contributor

Calculate most restrictive value

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;3FA406C3-68A0-4331-8B5D-BA45D17FA053.jpeg

 Desired output;

35F09669-B54D-4C86-A219-DFC213E9B9C4.jpeg

 

Tried with   If(sum(aggr(sum(aggr(sum(Boolean),Code,Category)),Category))=sum(aggr(sum(aggr(max(sum(Boolean)),Code,Category)),Category)),1,0)

Labels (1)
1 Reply
Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.