6 Replies Latest reply on Dec 29, 2018 4:57 PM by Praveenareddy Bandi

    Count Based on Dates

    Praveenareddy Bandi

      Hi,

       

      I need help on this calculation.

      I want to count all the IDS where Date is between Begin of Week and End of Week  and display for each record as Count

       

      Ex : for records Begin of Week 8/4/2018 and End of Week 8/10/2018 the count is showing as 10 instead of 25

      Here 25 records have Date between 8/4/2018(Begin of Week) and 8/10/2018(End of Week)

       

      My calculation for count is

      { Fixed [Begin of Week],[End of Week]: COUNTD(IIF((DATE([Date]))>= DATE([Begin of Week]) and DATE([Date]) <= DATE([End of Week]),[ID],NULL))}

       

       

      Please suggest?

       

      Thanks