improve performance time response

[Anonymous]

I have a QVW in which there are two many IFS

expression for example

=if(IsNull(GetFieldSelections(Week,'*')),Sum({$<Year={$(=max(Year))}>}[Prix de vente TTC]),Sum({$<Weekyear= {$(=max(Weekyear))}>}[Prix de vente TTC]))

Is there a way to include this expression as variable that I can use it wherever I need it ?

Is there anothor way to improve performance ?

[simenkg]

Cant you just change this expression to
Sum({$<Year={$(=max(Year))}>}[Prix de vente TTC])

?

[Anonymous]

I have two year fields