0 Replies Latest reply: Jun 19, 2018 4:31 PM by Jeremiah Bakerstull RSS

    Create a set analysis expression

    Jeremiah Bakerstull

      The formula below identifies a client as "New Household" if the client's first entry date is greater than or equal to start of report period.

       

      The total number of "Yes" under New Household column is 202. I would like to display the total yes count in a condition block. What is the best way show the count? Would it be using KPI?

       

      Can the formula below be concerted into set expression?

       

      =If([Entry Date]>='4/01/2018' and (If([Entry Date] = Min(TOTAL <[Client Id]> [Entry Date]), 'First')) ='First','Yes','No')