Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a SET expression it work for many year , today suddently it cannot work . Table 1 it only display JAn and Feb 2019 sales , which is wrong , as it never display sales after March.
money(
SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales/1/1000)
, $(vMoneyFormatK))
Table 2 can display Jan till Dec 2019 sles. which is correct.
SUM(sales)
Hope some one can advise me.
Paul
Hi All
Enclosed my QVW
Paul
Hi Paul,
Sorry if I misunderstand, but are you looking for the sales values for 2019 with month as a Dim.
What is wrong with:
money(
sum({<year = {'$(=Max(year))'} >} sales/1/1000)
, $(vMoneyFormatK))
Hi Sir
Your simplify and short expression is also work , but for my expression I make full use of all SET command to make my table better. Like able to perform aggr sum , auto detect current month etc...
Paul