4 Replies Latest reply on Sep 7, 2016 7:46 AM by tancrde.fde

    Problem with new vs returning clients

    tancrde.fde

      Hi,

       

      I am struggling to understand why the sum of my new and returning clients gives me a higher number than the total number of clients.

       

      My calculated field for 'client type' is the following:

       

      IF [Dat Ach] = {FIXED [Id Client] : MIN([Dat Ach])} THEN "New"

      ELSEIF  [Dat Ach] > {FIXED [Id Client] : MIN([Dat Ach])} THEN "Old"

      END

       

      See screenshot:

       

      With countd(Id_client)

      Capture2.PNG

       

      With 'client type' calc added to row:

      Capture1.PNG

       

      Thank you