QuarterStart date is showing 10/1/2018?

[sivaboggarapu20]

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

[sunny_talwar]

What is the Max(Date) showing?

[sivaboggarapu20]

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

[sunny_talwar · Accepted solution]

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)

[sivaboggarapu20]

Hi Sunny,

Excellent its working fine

Thank you so much for quick response

Thanks,

Siva