3 Replies Latest reply on Nov 27, 2018 2:53 PM by Zhouyi Zhang

    Condition in LOD Function

    Nipa Madhani

      I want to identify those emails with their no. of bookings, who have made the bookings in both the years i.e 2017 and 2018.

       

      Below formula does not filter out the years.

       

       

      { FIXED [Email data],YEAR([Booking Date]) = 2017 AND YEAR([Booking Date]) = 2018 : COUNTD([No. of Bookings]) }

       

       

      Can anyone please help me with the correct formula?

       

       

      Thanks,

      Nipa