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

    LOD Minimum but Exclude Zeros

    Siobhan Magee



      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,