Subtracting from a variable (not in a set analysis)

[sibrulotte]

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.

[Gysbert_Wassenaar]

Can you post an example document that explains your problem?

[qliksus · Accepted solution]

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

[sibrulotte]

$(=Anne_financiere)-1

That worked.