How to calculate total growth for current yerar over previous year

[Anonymous]

Hi i want to write an expression for total growth

expression for curremt year

=num(sum({< Sold_Year = {"$(=Max(Sold_Year)"}>} [inv value]/Sales_INR_Unit),'#,##0.0')

for previous year

=num(sum({< Sold_Year = {"$(=Max(Sold_Year)-1)"}>} [inv value]/Sales_INR_Unit),'#,##0.0')

[amilafdo]

Hi use below command

=(

(

(num(sum({< Sold_Year = {"$(=Max(Sold_Year)"}>} [inv value]/Sales_INR_Unit),'#,##0.0'))

-

(num(sum({< Sold_Year = {"$(=Max(Sold_Year)-1)"}>} [inv value]/Sales_INR_Unit),'#,##0.0')))

/

(num(sum({< Sold_Year = {"$(=Max(Sold_Year)-1)"}>} [inv value]/Sales_INR_Unit),'#,##0.0'))

) *100

Regards

Amila

[Anonymous]

Num((sum(if(Sold_Date >=AddYears(vstart,0) and Sold_Date<= AddYears(vend, 0), [inv value]/Sales_INR_Unit))))

-

sum(if(Sold_Date >=AddYears(vstart, -1) and Sold_Date<= AddYears(vend, -1), [inv value]/Sales_INR_Unit))

/

sum(if(Sold_Date >=AddYears(vstart, -1) and Sold_Date<= AddYears(vend, -1), [inv value]/Sales_INR_Unit))

this expression is not giving a correct reason