Max Month

[rcorcoran]

  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

[alexandros17]

The correct sysntax is:

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

let me know

[tresesco]

Only for max month? Try:

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

Note: Removal of the '<' sign.

[its_anandrjs]

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))