Actual order in current week

[UlfDofeldt]

Hello,

I want to have the total sales in current week. My week starts on Monday.

I have used the same formula for other calculation and its working but not for the recieved orders.

The below formula is what I use. I have a result but there are values missing.

Could someone please help me?

=Count( distinct{<filterToAvoid=,[Received date.autoCalendar.Date] ={">=$(=weekStart(today()))<=$(=weekEnd(today()))"}>} orderId)

[BenjaminT]

Hi,

I've had similar problems doing date ranges like this in set analysis in the past.

Now I always use dates in numeric formats for this purpose and have no issues, so I would recommend trying that.

In your load script you would need to load a new field which contains the date as a number and then use your set analysis above but with NUM(weekstart(today())).

Hope it works!

Ben