Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings, community,
I'm curious about the reason behind the inaccurate sums shown by this particular formula.
=Count(DISTINCT If(Aggr(NODISTINCT Max(Date), Date) = Date, ID))
Upon exporting to Excel, the tally doesn't match the expected total of 58,306.
I would greatly appreciate your assistance. Thank you very much.
Why would the expected total be 58306? You are counting distinct values, which presumably can repeat over multiple months (but are not counted twice for the total)?