topic Re: Set Analysis, date variable in App Development

Set Analysis, date variable

mrbalyaqv — Sat, 16 Nov 2024 04:42:33 GMT

Hi all!

I'm trying to make a table with comparison of sales for different periods. User should select one sale period first, and then table would show data for that period and same period from previous year.

Sale periods are in 'YYYY-MM-DD' format with DD = '01'.

I use variables below:
v_sf_MaxPeriod = date(max(saleperiod), 'YYYY-MM-DD')
v_sf_PriorYearDate = date(addyears(max(saleperiod),-1), 'YYYY-MM-DD')

I checked their values in text object, they're ok.

Expression (1) for selected period works correct:
SUM({<saleperiod={"=$(v_sf_MaxPeriod)"}>} sf_fact_count)

Same expression (2) for same period in previous year doesn't work:
SUM({<saleperiod={"=$(v_sf_PriorYearDate )"}>} sf_fact_count)

It returns same result as the previous one. But if I change expression (3) to:
SUM({<saleperiod={"<=$(=$(v_sf_PriorYearDate))>=$(=$(v_sf_PriorYearDate))"}>} sf_fact_count)
it works correct.

Why my expression (2) doesn't work? How to fix it?

Re: Set Analysis, date variable

sunny_talwar — Wed, 11 Sep 2019 12:40:21 GMT

Can you try one of these

Sum({<saleperiod = {"$(v_sf_PriorYearDate)"}>} sf_fact_count)

Removed = before $ in the above expression

Sum({<saleperiod = {"$(=$(v_sf_PriorYearDate))"}>} sf_fact_count)

Added $(...) in the above expression

Re: Set Analysis, date variable

mrbalyaqv — Wed, 11 Sep 2019 12:47:53 GMT

Thanks, Sunny! Second expression works. I was sure, that I've already tried it before, but may be I misspelled somewhere.