SET expression after change to IF expression give wrong result

[paulyeo11]

Hi All

Below expression work fine :-

Sum(Aggr(SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales/1), GROUP_TYPE))

when I change the above expression to below , it return wrong result.

Sum(if(Year_n<'2',sales/Rate,GROUP_TYPE))

May i know where go wrong ?

Paul

[prma7799]

Try this

Sum(if(Year_n<'2',(Sum(sales) / avg(Rate)),GROUP_TYPE))

or

Sum(if(Year_n<'2',(Sum(sales) / Sum(Rate)),GROUP_TYPE))

[paulyeo11]

Hi Sir

Enclosed Table 1 using SET expression , the result correct.

I try using your suggest expression on IF not working.

Paul Yeo

[prma7799]

Try this

=if(Year_n<'2',(Sum(sales) / avg(Rate)), (GROUP_TYPE))