Previous Function Cut-Off Date
I have a formula written that takes "Company Churn" / "Previous Revenue"
Previous revenue = PREVIOUS(Revenue)
The formula works for the individual months, but when it does the summary the rates are incorrect because it always has one month more worth of data in the revenue line item.
Is there a way to say "If the period is after the switchover date then 0 else *Insert formula*"?
Thanks in advance