Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to show a list of quote reference numbers (i.e. a dimension) which fall within a specific date range.
The set expression i have for the date range is:
[Expiry Date]={">=$(=monthstart(Today()))<=$(=monthend(addmonths(today(),2)))"}
But not sure how to write the complete set analysis. Can someone assist please?
Many thanks
What is wrong with the set analysis? Is it not giving you what you expected from it?
Hi Kristen
Something like following should get you close:
AGGR(ONLY([Expiry Date]={">=$(=monthstart(Today()))<=$(=monthend(addmonths(today(),2)))"} [Quote Reference Number]),[Quote Reference Number])
@sunny_talwar , I think Kristen wants the list of reference numbers which satisfy his condition (i.e. set analysis in a dimension rather than a measure).
Hope it helps.
Regards,
Mauritz