Replies posted by Scott Bennett
I found a way to find the YTD total of the previous year compared to the YTD Total of the last complete month. Here’s the custom filter I used:DATE-FIELD-YEAR=trunc_years(add_years(-1,now())) AND extract_months(DATE-FIELD-MONTH)<extract_months(trunc_months(now()))The DATE-FIELD-YEAR is the date field you’re filtering on, but specifically the yearThe DATE-FIELD-MONTH is the date field you’re filtering on, but specifically the monthI hope that helps! Scott
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.