## why is my result getting multiplied by 17??

## why is my result getting multiplied by 17??

(OP)

thread767-1267707: why is my result getting multiplied by 10????

I have a report i am writing, pulling info from a SQL table.

The Sum of each cost type is multiplying by 17. For example the total should result in $1,260,415 and I'm getting $21,427,055. 17 is the number of subcontracts for this particular job.

Below is the formula for all of the cost types.

Sum ({@CT1}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT2}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT3}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT4}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT5}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT6}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT7}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT8}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT9}, {brptJCCostRev;1.Contract})=0 and

Sum ({brptJCCostRev;1.ActualCost}, {brptJCCostRev;1.Contract})=0 and

Sum ({brptJCCostRev;1.BilledAmt}, {brptJCCostRev;1.Contract})=0 and

{?ShowZeros}='N'

In another thread, the user figured out that there was no filter in place to limit the sub contracts it was pulling amounts from, so it was pulling the amounts for everything - 10 times (b/c there were 10 sub contracts). How do I set this filter to only take the one total of the cost type and not multiply it by the number of subcontracts?

I have a report i am writing, pulling info from a SQL table.

The Sum of each cost type is multiplying by 17. For example the total should result in $1,260,415 and I'm getting $21,427,055. 17 is the number of subcontracts for this particular job.

Below is the formula for all of the cost types.

Sum ({@CT1}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT2}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT3}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT4}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT5}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT6}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT7}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT8}, {brptJCCostRev;1.Contract})=0 and

Sum ({@CT9}, {brptJCCostRev;1.Contract})=0 and

Sum ({brptJCCostRev;1.ActualCost}, {brptJCCostRev;1.Contract})=0 and

Sum ({brptJCCostRev;1.BilledAmt}, {brptJCCostRev;1.Contract})=0 and

{?ShowZeros}='N'

In another thread, the user figured out that there was no filter in place to limit the sub contracts it was pulling amounts from, so it was pulling the amounts for everything - 10 times (b/c there were 10 sub contracts). How do I set this filter to only take the one total of the cost type and not multiply it by the number of subcontracts?

## RE: why is my result getting multiplied by 17??

You could use either a Running Total or a Variable so as to accumulate the total only once for each contract.

If you require more specific instructions you will need to provide more details on the report structure (grouping, location of the formula provided, details of 9 @CTÃ— formulas etc.)

Hope this helps.

Cheers, Pete

## RE: why is my result getting multiplied by 17??

Report Header

Page Header

Group Header #1

Group Header #2

Group Header #3

Details

Group Footer #3

Group Footer #2

Group Footer #1

Page Footer

Report Footer

## RE: why is my result getting multiplied by 17??

ORa Variable.I am still a bit confused by the "= 0" against each of the formulas above and the reference to "{?ShowZeros}='N'".

Is what you have shown above, the contents of another formula, a

formula or simply a typo?Group SelectionAssuming the 11 formulas above are all sitting in GF3, Grp 3 is {brptJCCostRev;1.Contract}), there are 17 rows of data (details section), all showing the same values for {@CT1}, {@CT2} ... etc, you could simply drag each of those {@CTx} formulas to GF3.

Does that help?

If you then need to add each of those amounts for totals in Grp2, Grp1 etc, that will require some additional work which I am happy to help with but I need to be sure I understand the situation before investing additional time to assist.

If you are happy to post a copy of the report with saved data, it might be easier than trying to explain it, but I understand you may not be prepared to do that.

Cheers,

Pete.

## RE: why is my result getting multiplied by 17??

So in the Detail Section their are the cost types: @CT1, @CT2, @CT3, etc.

Each of these have the following formula:

if {brvJCContStat.CostType} = 1 then {brvJCContStat.ActualCost} else 0

So how do I edit this formula so that each Cost Type is not multiplying the correct amount by 17 (the number of subcontracts for this job)

## RE: why is my result getting multiplied by 17??

A screenshot showing the section names might help.

## RE: why is my result getting multiplied by 17??

## RE: why is my result getting multiplied by 17??