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

    Max Month

    Rhona Corcoran



      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





      =(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