$(Columndim89) is affect 2020 result

[paulyeo11]

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

[paulyeo11]

Hi All

Enclosed my QVW.

[paulyeo11]

Hi All

I found the issue , it is due to other table that cause the issue.

Thank 

Paul