local_phone(877) 456-7632 local_post_officeinfo@msxgroup.com
close
Message Boards
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
btamulis

Registered:
Posts: 1
Reply with quote  #1 
I have a consolidated balance sheet 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' 

Can MR do this?
Derek.Krebs

Moderator
Registered:
Posts: 109
Reply with quote  #2 
Yes, MR can handle such report and this will be done via a formula in the Row Definition and/or no-print rows w/ calculation priority reviewed (either row formulas 1st or column formulas first). 

You may export the report in question and email to me and I will gladly look at it and provide instruction on the formula. (Company | Building Block Groups then Export to .tdbx file and zip up with details to rows in question). 


Derek Krebs
Derek.Krebs@MSXgroup.com
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.