Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Cant you just change this expression to
Sum({$<Year={$(=max(Year))}>}[Prix de vente TTC])
?
I have two year fields