Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Suppression for a Page Header 1

Status
Not open for further replies.

mdcson

Technical User
Jan 19, 2011
38
US
I am doing a Profit and Loss report where I have a calculation of EBIDA (which is revenue - expenses) that must appear below expenses. It should have this order:

Revenue Data
Revenue Total
Expenses Data
Expenses total
EBIDA
Other Income and Expenses
Net Income (EBIDA - Other inc and exp)

Groupings:
Grp2 Rev and Expenses
Grp3 EBIDA calculation
Grp4 Subcategories of Rev and Expenses
Grp5 Subcategories codes

My revenue and expenses, which also includes the Other Income and Expenses are in Group 2. I have a formula that separates Other Income and Expenses so that its total is not included in Expenses and appears in its own section.

I am having difficulty in including the EBIDA calculation to appear above the Other inc and exp.

I decided to put the EBIDA calcs in GH3 which would work, however, there are two prior locations in the report where, of course, that same header would appear.

I learned a bit about conditional suppressing and went into section expert under GH3, clicked on suppress and utilized GroupNumber =1. This eliminated the first appearance of the header but not the second one. I only need that header to appear on its last occurrence.

I feel I am close but just can't get the right calc. I even tried onlastrecord xor recordnumber =1 but also only removed the first occurrence.
 
For each group, what is the field you are grouping on? It looks like you are identifying what fields you placed in the group sections, not necessarily the fields you grouped on.

-LB
 
You mean in group 3 where I am placing the EBIDA calc. That was also something I was not sure of and could certainly be the source of the issue. It is a column that essentially has the same code all the way down in the data set, a primary key, giving me the entire data set.

I just need to get this calc after expenses but ABOVE the Other Expenses. The only way I can see to do this is by putting the calcs in the header and they do calc the way I need them to. I just have the issue of this header appearing two prior times and feel that there must be a way to suppress the other two.
 
I think you should insert another GH2 section, GH2_b, and remove the Group #3. Then place the EBIDA calculation in GH2b and go into the section expert and format that section to "suppress blank section" and also to suppress->x+2->enter:

{table.group2field}<>"Expenses"

This assumes that instances of Group #2 are:

Revenue
Expenses
Other Income and Expenses

-LB
 
Thank you! I just had to alter the code to read {table.group2field}in ["Revenue","Expenses] and I'm good to go.
 
I am now doing the same report but at a more micro level. The last report was a roll up of all departments. This report is the same but at department level. Thus, my groupings are the same with the exception of department being at group 1.

So, at the end of each department, I need to have :
EBIDA
Other Income and Expenses
Net Income (EBIDA - Other inc and exp)

In this case, when I do what I did in the last report, I get an inflated amount which does not equal the rev-exp for the specific department. I DO get the correct amount, when I go into select expert and select just one specific department.

What am I missing?
 
I mean to say, I get an inflated EBIDA calculation. Everything else works fine.
 
I have figured this out. It involves the using of a running total on change of group 1 for each record.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top