Sum with multiple conditions

[GeromA]

Hi all,

trying to create a formula in a chart that would give me the value of a previous year (as part of a another calculation). The below give me the correct value for the current year (year(DATE)) but not for the previous one (year(DATE)-1):

fabs(sum({$<[Criteria1]={'86','87','88','89','93','94','95'},[year(DATE)]={[year(DATE)-1]}>}VOLUME))

Appreciate your ideas to solve this.

Many thanks.

[PradeepK]

There are different rules for assigning values to Set Modifiers.

Use Below link.. for reference.

Set-Analysis-with-yearstart-and-yearend-dates-not-working 

[GeromA]

Dear PradeepK,

thanks for the link. I'm, however, not able to modify the my code in a way it would bring up the correct result.

Would you have a solution for the code?

Many thanks,

GeromA