Hi @Liz, the discrepancy is because QS is taking the date 2022/05/31 as begining of the date, therefore, the YTDsum gives you data to the 2022/05/31 00:00:00, leaving the line for 2022/05/31 blank.
You can set the date to 06/01 or add one day to your formula.
Hi @emilyzhu adding another date works for YTDsum but what about weekly sums or monthly sums? Adding a day to the last date of the week/month rolls the week/month to the next period! Currently trying to solve this issue by adding 23 hours and 59 minutes to the time. Would love to know if there’s a better solution! Thanks