Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Could you please help me with the syntax? I'm trying to subtract the current max month Quarter Value from the Previous max month Quarter value.
I have created two variables.
Let vCurrentQtr = 'Q' & ceil(month(today()) / 3)&'-' & Year(today());
Let vPreviousQtr = 'Q' & ceil(month(addMonths(today(),-3)) / 3)&'-' & Year(addMonths(today(),-3));
but while set analysis at the front end using this formula gives me an error
sum({<Date={$(vCurrentQtr)}>}budhrs)-sum({<QuarterYear={$(vPreviousQtr)}>}budhrs)
Please see attached screenshot for an error. Can anyone help me fixing this syntax? Thanks in advance!
If possible share your app.
@Kushal_Chawda Thank you so much! It worked for me!
Another question on the same topic - It's providing the difference between the current and the previous quarter.
What changes do I need to make if I need sum of BUDHRS FOR max month of the previous quarter?
@dia2021 try below for max month of previous quarter
sum({<Date={">=$(=monthstart(quarterend(today(1),-1)))<=$(=quarterend(today(1),-1))"}>}budhrs)
@Kushal_Chawda Thank you so much !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I'm getting numbers as expected 🙂