Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I Wrote below expression. QuarterStart date should show 4/1/2018. But below expression is showing Quarterstart date is 10/1/2018?
Can any one help me?
sum({<Date=, Year=, Month=, Quarter=, Date={">=$(=QuarterStart(Max(Date)))<=$(=Max(Date))"}>}BlendedCost)
Thanks,
Siva
So, you want it based on today() not Max(Date) it seems... how about this?
sum({<Date=, Year=, Month=, Quarter=, Date={">=$(=QuarterStart(Today()))<=$(=Today())"}>}BlendedCost)
What is the Max(Date) showing?
Hi Sunny,
Max(Date) is showing 12/1/2018.
Using above expression I need to find Quarter sales from 4/1/2018 to 6/30/2018
Thanks,
Siva
So, you want it based on today() not Max(Date) it seems... how about this?
sum({<Date=, Year=, Month=, Quarter=, Date={">=$(=QuarterStart(Today()))<=$(=Today())"}>}BlendedCost)
Hi Sunny,
Excellent its working fine
Thank you so much for quick response
Thanks,
Siva