3 Replies Latest reply: Oct 10, 2012 6:05 AM by Peter Mitchell RSS

    Set Analysis Question



      I'm trying to get a simple set analysis expression to work.  All I want to do is show the current days average regardless of the selection criteria chosen.  I tried the formula but when I change dates the calculation changes. 


      avg({1< KeyDate={'=date(today())'}>} HA1) / 100


      Can anyone help me to get this working?