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:

       

      Sum(MTD_BUDGET_AMT)

       

      This expression gives me the correct date of 9/30/16:

       

      =Monthend(Max({1<MTD_GL_AMT={">0"}>}TRX_DATE))

       

      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.

       

      =sum({$<TRX_DATE={$(=vCurGLMonth)}>}MTD_BUDGET_AMT)

       

      Thoughts?

       

      Thanks!

      Cassandra