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
Quote from: mark123 on 12 Feb 2016 02:15:02 PM
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.
yes it is singleton and from same query as list
Quote from: mark123 on 15 Feb 2016 03:31:48 PM
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.
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