Conditional Sum Last 7 Days

[Anonymous]

I'm trying to make the sum of the last 7 days.

I created the variable vUltimos_7dias.

=(Today()-7)

But when I make the sum as follows, it does not spin, I have already tried in several ways:

Sum({<Data = {>={$(vUltimos_7dias)}>}Visitors)

Thanks.

[jcarlosmh]

is Data in numeric format or date format? Today()-7 represents as number not as date

[petter · Accepted solution]

Try this:

Sum( { < Data = { ">=$(vUltimos_7dias)" } > } Visitors )

You might also need to change the vUltimos_7dias to this:

=Date(Today()-7)