4 Replies Latest reply: Feb 22, 2016 10:08 AM by Joanna Seldon RSS

    using min / max - filter pane expression

    Joanna Seldon

      Hiya

       

      I have the following expression in a filter pane

       

      If(((Frac([Order Date]))>=(21/24) OR (Frac([Order Date]))<=(8/24)), 'Night', 'Day')

       

      I wish to add the min function

       

      If(((Frac(min([Order Date])))>=(21/24) OR (Frac(min([Order Date])))<=(8/24)), 'Night', 'Day')

       

      I cant seem to get this to work

       

      please help