Variable is not working Properly

[mhmmd_srf]

HI All,

I have a report where I want to show value on Date Selection. If I select any date, value should be calculating till date.

So I need to use expression like :

=Count({<DT={'<=$(=$(v1))'}>}OrderQuantityOutstanding),

But first I wanted to check whether my variable is working or not. So instead of <= I use only =.

But then also my value is not matching.

I have created two Text Object. With Variable and W/O Variable. Ideally these two should match. But with variable is showing less data.

I am attaching my file.

Could you please check and help me. I am not able to understand where I am making mistake.

Please help.

Thanks,

Sarif

[sunny_talwar · Accepted solution]

One of the text box expression is doing the sum and the other one is doing a count.... You need to either do a sum in both or count

[sunny_talwar]

Check the attached

[mhmmd_srf]

Ohhh...my GOD...

I am really sorry Sunny...for wasting your time...

Thanks a lot...