I'm trying to create a P&L statement in CR. We have approximately 40 GL accounts. Sometimes multiple GL accounts will be used to give a total for an account description on the P&L. For instance "Materials" may consist of "Purchases", "Inventory Variance" and "Raw Material" I created formulas that will total the account descriptions but now I'm not sure how do I display it on the report. If I put @Materials on the Details section and refresh the report, it will show zeros or empty spaces if I select to 'suppress if zero' on the report for each of the 40 GL accounts. All I want to see is just one line of information.
Can you show a picture of what you are getting and what you want?