Hello,
I am trying to achieve some calculations using summary fields within the reports. This is what I am trying to do and cant figure a way to do it.
Group A
Subgroup Sum A1
Subgroup Sum A2
Subgroup Sum A3
Subgroup Sum A4
Group A Total
Group B
Subgroup Sum B1
Subgroup Sum B2
Subgroup Sum B3
Subgroup Sum B4
Group B Total
I am trying to create a formula fields to calculate B2/Group A Total. How do I select only the respective summaries. I can select one of the summaries using a condition on the group name in the formula field, but can’t figure out how to use 2 different fields from different levels of grouping in the same formula.
Appreciate any help I can get. As usual, thanks to all.
vatsahs (BOB member since 2007-12-05)