Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My below expression work fine :-
Sum({<year = {$(=Max(if(getselectedcount(year)=0,2015,year))-0)} , month = {"<=$(=Max({<year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}, cOST={"cOST"} >} Amount*-1)/Rate/1000
To reduce maintenance , i like to change to using :-
year = {$(=Max(year)-1)}
Paul
Is this what you are looking for?
Sum({<year = {$(=Max(year) - 1)} , month = {"<=$(=Max({<year={$(=Max(year) - 1)}, sales = {'*'}>} month))"}, cOST={"cOST"} >} Amount*-1)/Rate/1000
my QVF
You still need the same output still? because just replacing getselectedcount with this new set analysis will change the numbers
Hi sunny
yes , it should be get the same result . because for this set of table i have 2016 data. in my previous table i dont have year = 2016
Paul
I can't think of way to get the same result without using some sort of the if statement. I will keeping looking though
It is possible to help me change then I check why ?
Sent from my iPhone
Change the if Statement? Not sure I understand Paul
Hi sunny
if IF statement i still can change the year ? by click on other year ?
Paul
Yes, if statement allows you to select year and use that year (the year you have selected)
can show me how you do it ?