variables in sum filter not working

[anagharao]

Hi All,

I cant seem to get the range selection right when i replace values with variables in a sum({}value) expression.

I've attached a example. The "Sales - Range" needs tweaking to work similar to "Sales - Values" with the difference of being dynamic.

[trdandamudi]

May be as below:

=SUM({<RowNumber={">=$('lLimit')<=$('uLimit')"}>}Sales)

[sunny_talwar · Accepted solution]

Try this:

=Sum({<RowNumber={"$(='>=' & $(lLimit) & '<=' & $(uLimit))"}>}Sales)

[anagharao]

Thank you !!