result line totals are calculating incorrectly

[Former Member]

I have a few columns that the totals are not correct. the individual ines are good but when you do the math for the totals it is not correct. I tried changing the aggregtion and the calculation filtes but that didn't help. It seems to only occur on fields that are using some sort of formula.

[Former Member]

Hello,

If you using only one formula, then setting Calculate result as Sum (or something else) should do it.

If you're using 2 colliding formulas then you need to specify formula collision.

This option works quite strange:

You have 3 options

default

use this formula

use competing formula

Thing is - only "use competing formula" in one and "default" in the other worked for me.

Combination "default" and "use this formula" had no effect.

BR

Ondrej

[Former Member]

I tried Sum and that didn't work. the calcuation uses a cacluation form another field so do I set it on that field?

[Former Member]

Please use Formula Collision on that CKF.

-Mayuri

[Former Member]

thsi s how the field is found

roll ft/min = est master footage/(total hours*60)

Est master footage = total qty / lanes

so it contains a formua within a formula

I tried the collison and that didn't work either

[Former Member]

I did tyr it on CFK and it still does not work. Does calculation or aggreagtion need to be set? I set the collission to use that formual

[Former Member]

Do you have any condition on the query?

[Former Member]

I have no conditions in the query. since this field is really dependent on other fields I owuld think it would some how have to be calcualted AFTER the query runs to get the correct result. At the line leve it is okay but it doens't have the ability to do the result until the end.

[former_member189638]

Can you please explain with some examples what exactly you are getiing in your report and what exactly you are looking for???

[Former Member]

sure. the example belwo shows you what is going on. the very last column I added and it shows the result as it shold be.

the calculatiion is column b / (column a *60) All single valudes tie but not the very last. it should be 1281.986

3.27 233,816.00 FT 473.49 1,191.32 1,191.316 *

8.25 589,138.17 FT 818.65 1,190.10 1,190.099 *

3.51 260,549.00 FT 1,062.38 1,236.88 1,236.881 *

0.19 87,184.34 FT 129.37 7,761.45 7,761.448 * 7,761.448 *

15.22 1,170,687.51 FT 415.18 969.62 1,281.986 *