Hello,
We have a column layout in our account schedules that shows the prior fiscal months before the current month. For example, column A is 2 months behind, column B is one month behind, column C is the current month, and column D is a Total that adds up the previous columns with the formula A|B|C.
If we use this on a row setup that has GP percentages it will add the percentages together instead of recalculating them.
Is there a way to have the row formula take precedence over the column formula?
Thanks.
*This post is locked for comments
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156