Count values that match the selected value in an different column

Anonymous — Thu, 01 Aug 2024 12:44:45 GMT

Hi,

In this data 'Directorate From' is linked to a separate hierarchy table against a field called Directorate. Directorate is a field users can filter by in the app. I want to create a calculation so that when 'Dir A', for example, is selected, a count of matching values in the 'Directorate To'. However this should only be when 'Directorate From' doesn't equal 'Directorate To'. In the example below, the answer would be 2 (as highlighted) and not 3.

The calculation would go in a straight table.

I hope that makes sense.

Thank you.

Re: Count values that match the selected value in an different column

morgankejerhag — Wed, 12 Feb 2025 20:45:36 GMT

Is the user making a selection on [Directorate To] or another field?

If the selection is made in [Directorate To] we could maybe do something like the total count - the count of equals

count([Directorate To])-count({<[Directorate From]={"$(=maxstring([Directorate To]))"}>} [Directorate To])

topic Re: Count values that match the selected value in an different column in App Development

Count values that match the selected value in an different column

Re: Count values that match the selected value in an different column