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

    Set Analysis Question

      Hi,

       

      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?

       

      Thanks,

       

      Pete