Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Table 1 expression using below expression working fine :-
money(
SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}$(ColumnDim51)/1/1000)
, $(vMoneyFormatK))
Table 2 expression using below expression not working fine :-
money(
SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}$(ColumnDim51)/$(Columndim89)/1000)
, $(vMoneyFormatK))
The different between above is :-
$(Columndim89)
When expression with $(Columndim89) , it return wrong for year 2020.
I try but cannot fine where go wrong ? Hope some one can help me.
Paul
Hi All
Enclosed my QVW.
Hi All
I found the issue , it is due to other table that cause the issue.
Thank
Paul