Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What error in the expression it is MTD calculation.
=Sum( {<[Util Daterep] = { ' >=$(=Max((MonthStart([Util Daterep])))) <=$(Max([Util Daterep]) ' }>} [Amount Verified])
Jay
You have to write
=Sum({<[Util Daterep]= {'>=$(=Max((MonthStart([Util Daterep])))) <=$(=Max([Util Daterep]))'}>} [Amount Verified])
Some Bracket and comma mistake
Regards
Anand
Small mistakes any other way of same problem.
Jay