Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
Hi Sir
Enclosed Table 1 using SET expression , the result correct.
I try using your suggest expression on IF not working.
Paul Yeo
Try this
=if(Year_n<'2',(Sum(sales) / avg(Rate)), (GROUP_TYPE))