Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The correct sysntax is:
=(Sum({$<[Physio Wait >12 wks]={20},ReferredMM={'<=$(=Max(ReferredMM))'}>}ActualValue))
let me know
Only for max month? Try:
=Sum({$<[Physio Wait >12 wks]={20},ReferredMM={"$(=Max(ReferredMM))"}>}ActualValue))
Note: Removal of the '<' sign.
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))