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

# Max Month

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

• ###### Re: Max Month

The correct sysntax is:

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

let me know

• ###### Re: Max Month

Only for max month? Try:

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

Note: Removal of the '<' sign.

• ###### Re: Max Month

Try with and put = sign on the expresion

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

Or

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