Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to something I thought would be pretty straightforward but just can't seem to crack this. I would like to sum up Sales for a fixed date range.
I'm ok with getting sales for a single date: sum({$<SaleDate={'1/23/2010'}>}Sales) and sales greater than a sale date sum({$<[SaleDate]={">=1/31/2019"}>}Sales).
But I can't figure out how to get two dates into my set statement say, a start date of 1/31/2019 and an end date of 2/15/2019 so as to get a sum of sales for all dates between the start and end sales dates...Any help would be much appreciated. I've checked a ton of posts but can't find a solution on this...
Clearly, this won't work...sum({$<[SaleDate]={">=1/31/2019", "<=2/15/2019", }>}Sales)
Also, I'd like to define a variable for all sales dates in a fixed month, say, January 2019 based on my SaleDate dimension. Not having any luck with this either.
Many thanks,
Chris
@cmclear22 My be :
Sum({<SaleDate={"$(= '>=' & '31/1/2019' & '<=' & '15/2/2019')"}>} Sales)
or you can use variable like :
vStartDate: date#('1/31/2019','M/D/YYYY')
vEndDate: date#('2/15/2019','M/D/YYYY')
The expression will be:
sum({<SaleDate={'>=$(vStartDate)<=$(vEndDate)'}>} Sales)
@cmclear22 My be :
Sum({<SaleDate={"$(= '>=' & '31/1/2019' & '<=' & '15/2/2019')"}>} Sales)
or you can use variable like :
vStartDate: date#('1/31/2019','M/D/YYYY')
vEndDate: date#('2/15/2019','M/D/YYYY')
The expression will be:
sum({<SaleDate={'>=$(vStartDate)<=$(vEndDate)'}>} Sales)