8 Replies Latest reply: Jan 16, 2014 11:41 AM by Michael Solomovich RSS

    Set Analysis MAX(DATE) Not resolving

    Phill Gilchrist

      I'm trying to do a simple sum for a list of matters.

      I want 2 values per matter.

      1, the last Bill Date which is working fine with:

          

      =DATE(AGGR(MAX(BILL_DATE), MATTER_ID))

       

      2, The last Bill value, which i thought doing BILL_DATE = the above would work, but isn't.

       

      MONEY(AGGR(SUM({$<BILL_DATE = {"=$(=NUM(AGGR(MAX(BILL_DATE), MATTER_ID)))"}>}BILLED_AMOUNT), MATTER_ID))

       

      Any help, greatly appreciated.

      Thanks