Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

MTD calculate

What error in the expression it is MTD calculation.

=Sum( {<[Util Daterep] = { ' >=$(=Max((MonthStart([Util Daterep])))) <=$(Max([Util Daterep]) '  }>} [Amount Verified])

Jay

2 Replies
its_anandrjs

You have to write

=Sum({<[Util Daterep]= {'>=$(=Max((MonthStart([Util Daterep])))) <=$(=Max([Util Daterep]))'}>} [Amount Verified])

Some Bracket and comma mistake

Regards

Anand

Not applicable
Author

Small mistakes any other way of same problem.

Jay