bradlee27514
IS-IT--Management
My data looks like this:
GH1 Invoice | Amount
D 1 | $10
GF1 1 | $10
D 2 | $5
D 2 | $5
GF2 2 | $5
where GF1 is group footer 1, D is details, and GF2 is group footer 2. I want to sum the Amount in the GF2 field for the whole data set. However when I do I get $20, when I should get $15. How can I make this sum work? I tried a formula where I wrote:
if
{#count of items on invoice} > 1
then
{@amount sum} / {#count of items on invoice}
else
{@amount sum}
However when I tried to sum this field I got an error message that the field could not be summarized.
The data has to be grouped like this because of how the report is designed (I can elaborate on this if needed).
GH1 Invoice | Amount
D 1 | $10
GF1 1 | $10
D 2 | $5
D 2 | $5
GF2 2 | $5
where GF1 is group footer 1, D is details, and GF2 is group footer 2. I want to sum the Amount in the GF2 field for the whole data set. However when I do I get $20, when I should get $15. How can I make this sum work? I tried a formula where I wrote:
if
{#count of items on invoice} > 1
then
{@amount sum} / {#count of items on invoice}
else
{@amount sum}
However when I tried to sum this field I got an error message that the field could not be summarized.
The data has to be grouped like this because of how the report is designed (I can elaborate on this if needed).