3 Replies Latest reply: Jun 16, 2014 5:23 AM by Anand Chouhan RSS

    Max Month

    Rhona Corcoran

        Hi

       

      I am trying to get the current month as the YTD figure rather than a sum of the months to date.

       

      The expression below is giving me a sum of Jan to current month even though i have max month in

       

      Any suggestions would be great

      Thanks

      Rhona

       

       

      =(Sum({$<[Physio Wait >12 wks]={20},ReferredMM={"<=$(Max(ReferredMM))"}>}ActualValue))

       

      Sorry none of the suggestions seem to work they are all  still bringing up the total of the months??

       

      Message was edited by: Rhona Corcoran