4 Replies Latest reply on Sep 11, 2018 4:28 AM by Siobhan Magee

    LOD Minimum but Exclude Zeros

    Siobhan Magee

      Hi,

       

      Does anyone know if it is possible to create an LOD to find a minimum but exclude zeros that may be in the data?

       

      My example is as below.  In this case Brand D has 0 clicks.  Whilst the Brand is present in the data it is not "live".

       

      I need to be able to select a brand eg Brand C and also bring back the max and min clicks.  The max is correct but in this case the min will always be zero.  How do I exclude the zeros?

       

      Many thanks,

      Siobhan