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

How accumulate (urgent)

Started by technol, 15 Oct 2009 01:22:27 PM

Previous topic - Next topic

technol

Hi, I have a request, basically is  amount accumulate per month, I was investigated and found the function running-total, I was allocated to:

ACCUM = running-total([amount] for [city])

I have got:

                                           Amount  ACCUM   
Spain                Madrid   Jan   20,128   20,128      
                   Feb   20,329   40,457      
                   Mar   20,812   61,269      
                Valencia   
                                        Jan   55,682   55,682      
                   Feb   52,108   115,469      
                   Mar   65,020   187,836      
                Toledo                
                                        Jan   35   35      
                   Feb   46   81      
                   Mar   1   82      
                Overall                234,161   481,039   
Venezuela   Caracas   
                                         Jan           
                    Feb           
                    Mar           
                Valencia    
                                         Jan   7,679   63,361  I'd have 7,679 
                    Feb   7,347   122,816   
                    Mar   8,965   196,801   
                 Barquisimeto   
                                         Jan           
                    Feb           
                    Mar           
                 Overall                23,991   382,978   

On the SECOND  Valencia city, the calculate is: spain.valencia  55,682 + Venezuela.valencia 7,679 = 63,361, it's bad, should be 7,679.  :o

Please, someone can I help me, with amount accumulate or it raise

Additional information. Properties

•   Classes : Crosstab member cell(calculated)
•   Solver order: it's setted
•   Aggregate function: Automatic