4,887
I have a consolidated balance sheet (3 companies) with a column - 'Intercompany Elimination'
The formula is 'B+C+D'
This is correct except for two rows where I want to 'zero' out the row. Basically we're eliminating an AR and AP intercompany accounts.
I can't see to figure out how to re-write my formula.
Something like: (in layman terms)
If dimension not '2100' then 'B+C+D' else '0' (where the dimension is intercompany AR account)
Can MR do this?
*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.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (