1 of 1 people found this helpful
I'm afraid I can only go back to 8.3! so can't post you a workbook you could open, but I think
will do the trick.
Let me know if not, and if so why and I'm sure we can get an iteration of this that will work...For example we might need a further condition COUNTD(IIF(NOT(ISNULL([SomeValue])),[Date],NULL)
No problem...It's only obvious when you see it!...many times I've been deep in analysis and end up trying to calculate something I think is going to be very complicated, and think I've achieved some sort of genius moments with a super-complicate-nested-table-calc...only for someone in the office (usually while I'm bragging about by Table Calc guru-ness!) to point out...'Yes but isn't that just the SUM of the Number of Records'....
Glad to hear I'm not the only one who likes to overcomplicate things!
Cheers again for the answer.