topic Re: Counting a Count? in App Development

Counting a Count?

Michael_Hart — Wed, 23 Mar 2022 06:47:32 GMT

Hi all,

I have a set of data that contains the location of items in a warehouse. As a simplified version:

I can then count the number of times a location is used.

I then want a KPI that shows the number of locations that only have 1 item.

i.e

2 locations have 1 item

How can I do this in one formula.

Thanks for the help.

joseph_morales — Wed, 23 Mar 2022 07:51:57 GMT

You can try this:

Sum (

if( Aggr( Count([Item no.]) , Location ) = 1 , 1, 0 )

)

Regards

RsQK — Wed, 23 Mar 2022 10:54:50 GMT

Hey, you can get the result like this:

COUNT({<Location={"=COUNT(Location)=1"}>}Location)

Michael_Hart — Wed, 23 Mar 2022 23:24:10 GMT

Thank you both, either solution seemed to get the answer I was looking for!

Much appreciated.