Sum on Absolute date values basis

[#1]

Hello

I have the followig formula that sum the sales of the prior week:

Sum( {<FECHA = {">=$(=WeekStart(Date(Today()-7))) <=$(=WeekEnd(Date(Today()-7)))"}>} TOT_COMISION_COMPARTIDA)

But when I select a filter, let say May 2015, the sum is not respect me the sum and the graphic dont show me anathig

is any form that this sum always gave me values no matter the date filters I select??

Best Regards

[swuehl · Accepted solution]

Try a set identifier 1 to disregard all selections:

Sum( {1<FECHA = {">=$(=WeekStart(Date(Today()-7))) <=$(=WeekEnd(Date(Today()-7)))"}>} TOT_COMISION_COMPARTIDA)

Alternatively, clear all selections in fields that might interfere with your FECHA modifier, i.e. selections in calendar fields, like Month, Year:

Sum( {<FECHA = {">=$(=WeekStart(Date(Today()-7))) <=$(=WeekEnd(Date(Today()-7)))"}, MonthField=, YearField= >} TOT_COMISION_COMPARTIDA)