Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
When i add below script , for reduce the data :-
NewFilteredTable:
NOCONCATENATE
LOAD *
RESIDENT sales WHERE
Year_n < 4;
DROP TABLES sales;
Below expression display null value :-
money(
Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}Exp/$(Columndim89)/1000)
, $(vMoneyFormatK))
Hope some one can advise me how to make it work.
Paul Yeo
My QVW
Hi
The expression seems correct but there no value available Measure field as "Exp" check below screen those fields shows as blank. check your BRD and update your measure accordingly. tks
Regards,
Deva
Hi Deva
Enclosed is the working copy , which i does not run the below script :-
NewFilteredTable:
NOCONCATENATE
LOAD *
RESIDENT sales WHERE
Year_n < 4;
DROP TABLES sales;
Notice that it return correct value.
So it is the Year_n field create the issue.
Paul Yeo