num(sum({<年={$(current_year)}, 月={$(current_month)}>} 售价金额)/sum({<年={$(last_year)}, 月={$(last_month)}>} 售价金额)-1

[lishuang]

Hi friends,

What's meaning of this expression " num(sum({<年={$(current_year)}, 月={$(current_month)}>} 售价金额)/sum({<年={$(last_year)}, 月={$(last_month)}>} 售价金额)-1, '#,##0.00%') "?

Thanks!

[sushil353]

Hi,

it is calculating the growth% from current month to same month last year...

Basis of the expression is Growth = (CurrentMonthSales - PreviousMonthSales)/PreviousMonthSales

so the same formula can be written as Growth = (CurrentMonthSales/ PreviousMonthSales)-1

HTH