Doubled Values

[Aaseemsood]

My Qlik sense expression doubles the value while using an expression for sum.

The same values in excel (the source data) is exactly half.

The expression used:

Sum({<Year = {"$(=Max(Year(TODAY())))"}>} [Spend in Euro]) 

Same is happening for all the graphs

[Chanty4u]

what result you are getting when you do this?

sum(disticnt  amountfield)     ?

try this

Sum(Agg(Sum({<Year = {"$(=Max(Year(TODAY())))"}>} [Spend in Euro]) , FIeld))