Max year function issue

kiansin — Fri, 09 Sep 2022 08:48:05 GMT

Hi ,

I have a expression script as above :

Sum ( {<SalesPeriodYearMth_DocDate={">=$(=Date(AddMonths(max({<Source={'Order Entered'}>} SalesPeriodYearMth_DocDate),-12), 'YYYYMM'))<=$(=Date(AddMonths(max({<Source={'Order Entered'}>} SalesPeriodYearMth_DocDate),0),'YYYYMM'))"}>} EURSales)

My expected output is EUR sales from year period "202111" until "202211"

(Current year period is "202211" and I need the table rolling by 13months hence initial by "202211")

--------------------------------------------------------------------------------

Once I was selected "Yes" from dimension "cyclone"

the year period auto changed to "202110 " until "202210" instead of "202111" until "202211"

it supposed to show the Invoiced from year period "202111" to "202211",

but it didn't , why ?

------------------------------------------------------------------------------------------------------------

As you can see as above :

It has data with "Cyclone" was equal to "Yes " in year period "202211"

But when I selected "yes" from column cyclone , it automatically ignore the year period "202111" and end with "202110"

Why?

Could anyone help on this issue please ?

Thanks in advance !!

topic Max year function issue in App Development

Max year function issue