Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I am filtering on Calendar.Year = 2022.
The result should show 12.2021 - 06.2022. But the expression is not working as expected. Any solution from your side?
if([Account]= '3000'
Sum({< [Calendar.Year]=, [Calendar.Month]=,
%Date={">=$(=MonthStart(Max(%Date), -13))<='01.06.2022'"}>} $(='Fact.AMOUNT_'&'_Amount')))
from the looks of it you are missing the comma to end the check and go to the True and after the False.
if([Account]= '3000'
Sum({< [Calendar.Year]=, [Calendar.Month]=,
%Date={">=$(=MonthStart(Max(%Date), -13))<='01.06.2022'"}>} $(='Fact.AMOUNT_'&'_Amount')))
you can do something like this:
if([Account]= '3000',
//True:
Sum({< [Calendar.Year]=, [Calendar.Month]=, %Date={">=$(=MonthStart(Max(%Date), -13))<='01.06.2022'"}>} $(='Fact.AMOUNT_'&'_Amount')),
//False
'False Statement'
)