If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Running-total relational data

Started by oscarca, 20 Nov 2018 03:39:45 AM

Previous topic - Next topic

oscarca

Hello Cognos community,

I have a data item that calculates the number of orders that a supplier didnt deliver in time for each month that looks like this:
case
when
([Received date] <> [Requested date] and [Ordered quantity] <> [Received quantity]) then 1
else 0
end

What I want to do is to create a running total for each month. So if I choose Mar I want to see the numbers Jan + Feb + Mar.

So I created a new data item using the data item above:
running-total([Wrong time, wrong quantity] at [Supplier],[Month] for [Supplier])

This is what it displays:
                                                           Jan              Feb               Mar
Supplier  Wrong time, wrong quantity       7                 3                  5
              Running-Total                           0                 0                  1


Desired result for running total would be:

                                                            Jan              Feb               Mar
Supplier  Wrong time, wrong quantity       7                 3                   5
              Running-Total                           7                 10                  15


This is a relational data source and thank you for all the tips on running-totals.

Best regards,
Oscar


oscarca

*Solved it*

It was an aggregation issue, so changed detailed aggregation to default and summary aggregation to total.