This content has been marked as final. Show 5 replies
I am trying to get the sum of MTD_BUDGET_AMT for the most recent month in which MTD_GL_AMT >0. Therefore, I think I need to use Set Analysis with:
This expression gives me the correct date of 9/30/16:
I'm trying to figure out the correct syntax. I would expect to see 48,478,839
I've also tried creating a variable with the above Monthend expression : vCurGLMonth but this doesn't seem to work either.