Set Expression with a Variable

[KPage]

Hello,

I am trying to calculate the total sales for the current week. "MaxWeek" is my Variable. "Dollar Sales" is my field. I am entering the expression below but not getting any results. Can someone please guide me to the correct expression?

sum({
    <[Date]= { "$(MaxWeek)" }>
    }
    [Dollar Sales]
    )

*MaxWeek==Date(Max({1<Date=$::Date>} Date))*

[PrashantSangle]

what is error you are getting?

what is expression MaxWeek contain

You can debug your own expression by taking it table

in Expression editor put your expression at bottom of expression window you will see what it is evaluating?

If that debug won't work for you then please share with us the snip of it. 

Regards,

Prashant Sangle