Hi. I need to create a report with two different formulas in the same column and am having trouble getting it to work. For example, in the variance column for revenues, I want the formula to be columns C-D. In the same variance column for expenses, I want the formula to be columns D-C. Any suggestions on how to best approach this?
Thanks!
sounds you need a if statement to identify which formulas you use in the column. such as if(i=1, C-D, D-C)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 683 Most Valuable Professional
André Arnaud de Cal... 563 Super User 2025 Season 2
Sohaib Cheema 398 User Group Leader