Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below expression , it will return YTD sales :-
Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/$(Columndim89)/1000)
Now i need to modify the above expression to display month closed. Meaning only display Jan and Feb sales amount exclude march sales amount.
So the result should only shown 1461
Paul
I think this one got already resolved, isn't it Paul?
Sum({$<year = {$(=Max(year)-0)}, month = {"<$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/$(Columndim89)/1000)
My Qv Doc!
Hi, paul yeo.
Excluding the march month, not would be 2461? Please, confirm.
Regards,
Jonas Melo.
I think this one got already resolved, isn't it Paul?
Sum({$<year = {$(=Max(year)-0)}, month = {"<$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/$(Columndim89)/1000)
Hi Jonas
Many SET expert here already give me the correct solution , as for the amount is not important , as my QV sampledata file keep changing. most impt is the right expression which already confirm by the expert here. Now i aware that the = sign is to handle month closed. and '*' is to handle don't select any date.... very interesting discovery.
Paul