Calculation Errors/variations

[Former Member]

I have extracted a list of costs against an ID. When the columns are added up via slice and dice at the bottom of the table the answer comes to 242,689.99 (formula: =Sum(<CST_Alt Cost(Query 3 with MCPCF23A)>)). However, if I insert a cell (Insert, Cell) to provide summary information at the top of the report and insert the same formula I get a completely different result - 137,174.15.

Any ideas out there?

[Former Member · Accepted solution]

Hi Chris,

The Behavior in your case generally happens in Case of Count (),CountAll().

Select any Column and apply count () you will get the correct result.

But using Insert-> Cell it gives value different than the value we get previously.

You are trying to sum values of column. The behavior you are getting may be because of following reasons.

1) The column on which you are applying Sum() may contain some duplicate values hence the sum is higher and Sum() calculates values against the ID

2) The column on which you are applying Sum () may contain 137,174.15. as the first value.

Please check above cases, I hope this helps.

Thanksu2026.

Pratik

[Former Member · Accepted solution]

Thanks for the reply.

I've looked at the 2 cases you have outlined:

1. The amount in the first row with a cost is not the value returned by Sum()

2. I have used a (known) unique identifier

3. The behaviour of the Sum() in the calculated Cell is as though I have a series of non-unique key even though I have now left this out from the query.