Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a rather simple expression:
=
sum(if([Année financière]= Annee_financiere
AND
[%CLE_Type_Transaction_ID] <>'EB'
AND
[%CLE_Type_Transaction_ID]<>'EA'
AND
[Période financière]<= 12 ,
Montant))
WORKS GREAT !
I'd like another expression to be Annee_financiere -1
So I tried:
=
sum(if([Année financière]= $(=Annee_financiere -1)
AND
[%CLE_Type_Transaction_ID] <>'EB'
AND
[%CLE_Type_Transaction_ID]<>'EA'
AND
[Période financière]<= 12 ,
Montant))
Returns zeros.
What am I missing. Do I really have to start aiming for a set analysis? If so what would it look like.
Hi,
If Annee_financiere is a variable stores number then use only Annee_financiere-1 instead of $(=Annee_financiere-1).
If it contains some calculation then try any of one from ( $(Annee_financiere)-1) / $(=Annee_financiere)-1
Can you post an example document that explains your problem?
Hi,
If Annee_financiere is a variable stores number then use only Annee_financiere-1 instead of $(=Annee_financiere-1).
If it contains some calculation then try any of one from ( $(Annee_financiere)-1) / $(=Annee_financiere)-1
$(=Anne_financiere)-1
That worked.