Forum Discussion
Month on Month - % difference
Hi, I have a series of facebook posts over a couple of years (by post date), including key stats - reach, impressions, engagement etc. - and am after some help creating month-on-month calculatio...
I mentioned this in my original reply but that was friday so i didn't think of it when i did my key date. Try changing that to this formula:
Key Date = DATE(YEAR([Published Date]), MONTH([Published Date]), 1)
This will align your data to the month, rather than the day.
I should also mention for completeness, the quick formula i wrote in my original reply is a Delta formula. To get a percentage just use the DIVIDE function instead which will look something like = DIVIDE(<First Calc Statement>, <Second Calc Statement)