Year over Year %

 Year over Year % =

VAR CYSales = [Sales Amount]

VAR PYSales = [Sales SPLY]     -- sample period last year

VAR Result =

IF (

    CYSales <> 0 && PYSales <> 0,

    DIVIDE ( CYSales - PYSales, PYSales)

    )

RETURN Result