Previous period sum calculation

[MK97]

Hello,

I have problem trying to calculate previous period sum. Current period calculation is correct, but previous period calculation is always showing current period values:

Two variables that are used in calculations: 

vMaxSelectedDate = Date(max(Date))

vMinSelectedDate = Date(min(Date))

Current period calculation:

sum({< Date={"<=$(vMaxSelectedDate)"}>} (AMOUNTMST)

Previous period calculation:

sum({< Date={"<=$(vMinSelectedDate-1)"}>} (AMOUNTMST)

Thank you in advance! 🙂

[BrunPierre]

@MK97Try these expressions;

Current period calculation:

SUM({$<Date = {"$(=Date(Max(Date)))"}>}AMOUNTMST)

Previous period calculation:

SUM({$<Date={"=$(=AddYears(Max(Date),-1))"}>}AMOUNTMST)

Best regards

[BrunPierre]

@MK97 Did it solve your problem? please mark accordingly.