5 Replies Latest reply: Nov 22, 2016 12:16 PM by Tresesco B RSS

    Set Analysis Syntax?

    Cassandra Baqir

      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.