Not getting correct total

[mark123]

Hi,

I need to display total of a column in a separate table above the list report instead of having a total column. I created a singleton object and inserted in the total table but i am getting the total wrong.
I should get identified count as 6 and amount as 550 but i am getting wrong values in the singleton above the list. I have attached a snapshot of output.

Its relational model.

Thanks,
Mark

[MFGF]

Hi,

I need to display total of a column in a separate table above the list report instead of having a total column. I created a singleton object and inserted in the total table but i am getting the total wrong.
I should get identified count as 6 and amount as 550 but i am getting wrong values in the singleton above the list. I have attached a snapshot of output.

Its relational model.

Thanks,
Mark

Is the singleton based on the same query as your list?

MF.

[mark123]

yes it is singleton and from same query as list

[MFGF]

yes it is singleton and from same query as list

Are you using the same items in your singleton that are being used in the list footers?

MF.

[cognos-t]

Hi Mark,

For me it looks like your singleton for the count is really counting numbers. Therefore you should use a total function on the count item instead.

The function should look like that total([Count])

For the amount you may try something like that: total([Amount] for report) in order to let cognos build a total for all elements in the query.

Regards