Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have beow expression at table 1 working fine , when i select current month and year :-
(
sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales/$(Columndim89))/1
-
sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} cost/$(Columndim89))/1
)
/
sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales/$(Columndim89))/1
Can some one share with me how to make the above expression still working when i not select current month and current year ?
Now Table 2 not working fine , because of above expression need to modify.
Paul
May be change the expression for the variable vSelectedDate to this:
=MonthEnd(MakeDate(Max({<sales = {'*'}>}year), Max({<sales = {'*'}, year = {$(=Max(year))}>} month),1))
May be change the expression for the variable vSelectedDate to this:
=MonthEnd(MakeDate(Max({<sales = {'*'}>}year), Max({<sales = {'*'}, year = {$(=Max(year))}>} month),1))
Your variable vSelectedDate could be changed to max(DATE) which will be return a value if nothing is selected and if some value(s) are selected it returns the max. value from the selected values.
- Marcus
Hi Sunny
Thank you for your help. there are some thing wrong in my org expression. I need to settle first.
Paul
Finally my chart GP % value is correct. I ever once have chart display wrong value because i click on null dimension , and no one have detect this mistake for 5 yr.