You’re offline. This is a read only version of the page.
I am wondering if it is possible to create an IF statement that looks at the year over year change in a line item. For example, if the margin in 2014 is 2% greater than 2013 then insert a number. I am running into trouble with referencing the prior years data.
Ultimately, I am trying to create a report that shows what caused the margins to decline or increase from the previous year. Any help would be great. Thanks.
*This post is locked for comments
You could possibly do this with an external excel spreadsheet and link it back in to MR. Does that seem feasible?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (