=Sum([Counter]) In ( [SO])
And counter = If([ChangeIndicator] = “Yes”) Then 1 Else 0
So this gives me this correct view:
But Counter is just a help column so I want to take this out.
However…:
I know I can just Hide the column Counter, but surely there is a way to reference Counter in the formula without Counter needs to be in the layout to get the correct number (82) in the layout?
Have a read up on calculation contexts. ForEach is the one that you want
Say you have a report on sports match attendances with just one row per club.
=sum([Attendance]) gives 1,402,000 showing that just over 1.4 million tickets were sold across a club’s 19 home games in the season.
=max([Attendance]) gives the same result in this context because you haven’t included any match information.
=Max([Attendance]) ForEach([Fixture Number]) adds Fixture Number to the calculation but not the block and gives 75,600 as your Max attendance
Given those examples, you should be able to apply that to your situation.
