KPI with date variable

[#1]

Hi experts!

I have this problem: I have a slider that set a DateVariable (VariableDate) defined like (=today()).

I need to show that variable with a KPI, and i simply added one formatted as Date with the expression =(VariableDate). (until this point everything ok)

I need also to set a kpi that shows the average of a field before the date i set with the slider. The expression I used is this one:

Avg({<FieldDate={'<=$(DateVariable)'}>} MyField)   but it does not show anything.

Anyone can help me?

Thankyou!

[sunny_talwar]

May be try this:

Avg({<FieldDate={'<=$(=DateVariable)'}>} MyField)

[OmarBenSalem]

If the variable is already defined as =TODAY() why add another = ?

Avg({<FieldDate={'<=$(=DateVariable)'}>} MyField)

Maybe the quotes are the problem?

and

Avg({<FieldDate={"<=$(DateVariable)"}>} MyField) would do the trick?