Calculating index vs Year Ago
i have a calendar date column and a sales$ column. i would like to calculate sales index vs year ago. How can i do that within Beast Mode?
Date: Calendar date
Sales IYA = (Sales $ on 15May2020) / (Sales $ on 15 May 2019) * 100
is there a way i can shift the date to create a (sales $YA) column?