Jump to content

Sum of sales limiting Day(DateTimeNow()) - 1, ParallelPeriod or Limit

Hesloan Viana

Recommended Posts

Hey all, i need to create a Bar Chart that shows me how the atual month is going compared to other months limiting the Day(DateTimeNow()) - 1.


If today is day 28 of August. I need to see, in my bar chart, the Sum([sales]) for all months (including August) until day 27.

If today is 2 of September then i need to see, in the bar chart, the Sum([sales]) of day 1 for all months .

I've tried using ParallelPeriod and Limiting Data likeDay([date_sale])=Day(DateTimeNow()) - 1, but it doesn't work.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...