InQuarter or what?

[#1]

Hi everybody

I wanna have a SUM(Money) in the actual quarter in the actual year like quarter to date

how can i do that?

Thanks,

Cheers!

[maxgro]

maybe with some flags (IsInQTD, IsInYTD) in the calendar as explained here

Year-over-Year Comparisons

[sunny_talwar]

‌Flags are usually the best option because it makes the application so much more efficient. But in case you cannot change the script or you are looking for an alternative solution, you can try this:

=Sum({<DateField = {"$(='>=' & Date(QuarterStart(Max(DateField)), 'YourDateFieldFormatHere') & '<=' & Date(QuarterEnd(Max(DateField)), 'YourDateFieldFormatHere'))"}, Quarter, Month, Year>} Money)