Independence to a field

[Anonymous]

Hello,

I would like to made an independence to the field Date for this formula, because it affect the result displayed:

And when the field Date is selected:

But it is not the good result.

The expression here:

=SUM(Value_AIR)/1000000

Do you have a solution please ?

Thanks in advance for your help,

Sébastien.

[sunny_talwar · Accepted solution]

May be this:

=Sum({<Date = >}Value_AIR)/1000000

Essentially, by add {<Date = >}, you will be telling the expression not to change based on selections

[Anonymous]

Thanks a lot !