topic Re: Count only instances where both yes and no in App Development

Count only instances where both yes and no

Mitch_Data — Mon, 13 Jun 2022 08:11:41 GMT

Hi,

I have a problem and I wish to know if anyone is able to help.

Problem:

I have calculation numbers like the screenshot below. For the value at the bottom of the table, 114286/1 and 114286/2 I have a question. As you can see the 114286/1 in the order column has 'lost' and 114286/2 has 'order'.

How can I make a formula that only counts the instances where a calculation number has both 'order' and 'lost'. I also made a column that seperates the calculation number from the " / "

Further question: Then, how can I only count the calculation numbers that only have 'lost'. So for instance 114286 ranging from 114286/1 to 114286/10 can never have a 'order' in that range.

Re: Count only instances where both yes and no

vinieme12 — Mon, 13 Jun 2022 09:00:17 GMT

=count( {<[CalculationnummerZonder]={"=count({<Order={'loss','order'}>}Distinct Order)=2"}>}Something)

=count( {<[CalculationnummerZonder]=p({<Order={'loss'}>}[CalculationnummerZonder])*p({<Order={'order'}>}[CalculationnummerZonder])

>}Something)

Re: Count only instances where both yes and no

Mitch_Data — Mon, 13 Jun 2022 11:54:25 GMT

Fantastic @vinieme12 , this is the solution. Many thanks!