Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need help for creating name set to until mount, I an traing to write the sum of sales until the selected mount with no success
My set is
=
sum({$<YEAR={2011},month={$(=only(month))}>} ,SALES
I need to make it month <= only(month)
somehow when i write
sum({$<YEAR={only(year-1})}>} ,SALES
it's ok but
sum({$<month={only(month-1})}>} ,SALES
it returns 0, wite the -1 only, way?
Hi Ester,
Please use AddMonths(date,-1) and extract the month from it.
Thanks,
Rajesh Vaswani