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.
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.