You’re offline. This is a read only version of the page.

Microsoft Dynamics GP (Archived)

Management Reporter Formula Question

(0) Share

Report

Posted on by Bron

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

I have the same question (0)

All responses (0)

Answers (0)

Helpful resources

Last 30 days Overall leaderboard

Dynamics 365 release plans