Calculate amount different from the selected date

[cristianj23a]

Hello
I am trying to calculate the amount different to the selected date. The date is accumulated, I mean that if you filter 05/31/2018 you must calculate the amount greater than May.Example:

I am filtering until May of 2018 and I like to import 1,892.12 dollars but it is not what I want.

If you filter until May 2018 you must calculate the amount from June 2018 to the current date, which should be 136.29 dollars.

 

please help me with this topic.
I attach the qvw.
Greetings.

[sunny_talwar · Accepted solution]

Try these expression

Importe USD

Sum( {<%OPERACIÓN={'PRESTAMOS'}, MesAño, Fecha. = {"$(='>' & Date(Max(Fecha.), 'DD/MM/YYYY') & '<=' & Date(Today(), 'DD/MM/YYYY'))"},Cuenta.=,Rubros=,[Centro Coste]>}  [Importe USD])

Importe PEN

Sum( {<%OPERACIÓN={'PRESTAMOS'},MesAño, Fecha. = {"$(='>' & Date(Max(Fecha.), 'DD/MM/YYYY') & '<=' & Date(Today(), 'DD/MM/YYYY'))"},Cuenta.=,Rubros=,[Centro Coste]>}  [Importe PEN])