-
Re: prior year
Sunny Talwar Apr 5, 2017 2:56 PM (in response to Salim DERGHOUM)Try this
annee={$(=Max(annee)-10)}
-
Re: prior year
Salim DERGHOUM Apr 5, 2017 3:01 PM (in response to Sunny Talwar )Values display are still values of year select only...
-
Re: prior year
Sunny Talwar Apr 5, 2017 3:03 PM (in response to Salim DERGHOUM)Can you show a screenshot of the field annee?
-
-
Re: prior year
Sunny Talwar Apr 5, 2017 3:09 PM (in response to Salim DERGHOUM)Are you making selection in other Date and Time related fields?
-
Re: prior year
Salim DERGHOUM Apr 5, 2017 3:13 PM (in response to Sunny Talwar )I use your expression without and with selection on annee field. Because, I want when I will select value 1981, I want value for 1971 and 1981 side by side.
-
Re: prior year
Salim DERGHOUM Apr 5, 2017 3:47 PM (in response to Salim DERGHOUM)I try to create a variable like this anneeV : $(=annee+10). Then I use this variable in a set analysis like this : sum(${<nom_Mesure={exp}, annee={$(=anneeV)}, nom_Du_Pays-={'Monde'}} valeur).
But value display are this of current year select...
-
Re: prior year
Sunny Talwar Apr 5, 2017 3:55 PM (in response to Salim DERGHOUM)How about this, doesn't work?
Sum(${<nom_Mesure={exp}, annee={$(=Max(annee) - 10)}, nom_Du_Pays-={'Monde'}} valeur)
-
-
-
-
-
-
-
-
Re: prior year
omar bensalem Apr 5, 2017 4:23 PM (in response to Salim DERGHOUM)Try this:
Sum({<annee=,annee={"$(=max(annee))","$(=max(annee)-5)"}>}YourMeasure)
-
Re: prior year
Salim DERGHOUM Apr 5, 2017 5:23 PM (in response to omar bensalem )Thanks, but my formula work finally, I need to add ">" before "}".
-