8 Replies Latest reply: Feb 2, 2016 11:32 AM by Cassandra Baqir RSS

    Set Analysis Syntax using Max(Date)

    Cassandra Baqir

      I need to modify this syntax to only include the max(FCST_DATE) and apparently this is not the right way to do it because I am still ending up with multiple FCST_DATEs for each APP_DATE:

       

      =Sum({$<FCST_DATE={"<$(=max(FCST_DATE))"},EXP_TYPE_CODE={'Capital'},APP={'FORECAST'}>}FCST_AMT)

      What am I doing wrong?

      2-1-2016 3-58-32 PM.jpg