5 Replies Latest reply: Aug 4, 2016 3:10 PM by jia li RSS

    Set Analysis With a Date Variable

    jia li

      Hey everyone, I am having some issues with my set analysis. This is what I currently have.

       

      Variable:

      vMaxTransDate = max(TranDate)

       

      Set Analysis:

      =sum({<SalesStat = {'Open'}, TranDate = {'=$(vMaxTransDate)'}>}SalesQty)

       

      This is not giving me the SalesQty for that max date but instead its giving me all the SalesQty till that max date. Would love some help with this. Thank you in advance.