4 Replies Latest reply: Jun 26, 2018 9:49 AM by Jeremiah Bakerstull RSS

    Sum based off If and dates

    Jeremiah Bakerstull

      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