Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this:
Sum( { < Data = { ">=$(vUltimos_7dias)" } > } Visitors )
You might also need to change the vUltimos_7dias to this:
=Date(Today()-7)
is Data in numeric format or date format? Today()-7 represents as number not as date
Try this:
Sum( { < Data = { ">=$(vUltimos_7dias)" } > } Visitors )
You might also need to change the vUltimos_7dias to this:
=Date(Today()-7)