Sum based off If and dates

[jbakerstull]

I'm trying to create a calculation that sums total number of instances where client's based off min date.

The objective would be to add addtional columns to count specific instances like primary reason for entry.

But for now, I'm just trying to get formula below to work.

=Sum(Aggr(If([Entry Date] = Min(TOTAL <[Client Id]> Floor(Num([Entry Date]))),1,0)

Thanks

[sunny_talwar · Accepted solution]

May be this

=Sum(Aggr(If([Entry Date] = Min(TOTAL <[Client Id]> Floor(Num([Entry Date]))),1,0), [Client Id], [Entry Date]))

[jbakerstull]

Thank you. The formula worked. Why was there need to add extra [Client Id], [Entry Date] at end of the formula?

[sunny_talwar]

You only were closing the if statement... but need to add the dimensions for the Aggr() function....

[jbakerstull]

ah, thank you.