7 Replies Latest reply on Sep 14, 2017 2:42 PM by Shinichiro Murakami

    LOD with COUNT and some conditions

    Elena Atzeni

      Hi everyone. I need an help to create a LOD that allows me to use the COUNTD formula with some conditions (IF formula).

       

      I need to monitoring a contest between a shop list.

       

      For each shop I have 2 clusters periods: “Start” and “Contest” .

       

      I need to calculate this relation between the 2 clusters:

       

      COUNTD (ID) / [COUNTD(ID)/3]

       

      I tried with these formula but they do not work:

       

      IF [cluster] = ‘Start’ THEN [id_Start] ELSE [id_Contest] END

       

      or

       

      COUNTD(IF [Cluster] = ’Start’ THEN [id_Start] ELSE [id_Contest] END)

       

      where

       

      id_Start:  COUNTD(ID)/3

      id_Contest: COUNTD(ID)

       

      Anybody could help me?

       

      Thank you!

       

      Elena