Set Analysis totals

[#1]

Hi,

I am  using the below expression to calculate the sum in a text box  but it is not returning the correct sum.

Sum({<[Billing Transaction Datetime]={"<=$(=Timestamp(Today()))"}>}[Billing Disbursement Amount])

The sum I am getting with this expression is -99 which is incorrect as per the data in below image.

Please help me with the same.

Regards,

Manu

[sunny_talwar]

What is the correct you are expecting to see? Would you be able to share a sample?