Hello,
I am trying to subtract current week values with previous week values and have the ability for this to update each week. How would I do this in Magic ETL? A lag function?
So 5-19 week would subtract from 5-12 week and then next week I would like to see 5-26 week subtract from 5-19.
Thanks,
Garrett