Set Analysis Question

[#1]

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

[#2 · Accepted solution]

Try this:

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

[jagan]

Hi,

PFA, hope it helps you.

Regards,

Jagan.

[#4]

brilliant - working now thank you both