And in Set Expressions

[Anonymous]

I am typing the following code:

Sum({<Payment_Date = {">$(=vBack_Test_1)"} , Payment_Date = { "<=$(=vPE_Date)" } >} Gross_Claims_Paid)

Basically I want to sum where Payment date is between vBack_Test_1 and vPE_Date. It is applying both condition 1 or condition 2 whereas I want it to sum only those claims between the two dates. If I just apply one condition it works so it means date format and syntax is correct.

Would appreciate some help here.

[m_woolf · Accepted solution]

Try:

Sum({<Payment_Date = {">$(=vBack_Test_1)<=$(=vPE_Date)" } >} Gross_Claims_Paid)

[sunny_talwar]

or this:

Sum({<Payment_Date = {"$(='>' & $(=vBack_Test_1) & '<=' & $(=vPE_Date))" } >} Gross_Claims_Paid)

Where this -> ='>' & $(=vBack_Test_1) & '<=' & $(=vPE_Date) in a list box should give you the range you want the expression to show and in the same format as Payment_Date

[maxgro]

Sum({< Payment_Date = {'>=$(=Date(vBack_Test_1))<=$(=Date(vPE_Date))'} >} Gross_Claims_Paid)

maybe you have to remove the Date function

Sum({< Payment_Date = {'>=$(vBack_Test_1)<=$(vPE_Date)'} >} Gross_Claims_Paid)