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

[Report Studio] Help with "For" syntax

Started by kristysmith, 29 Dec 2006 02:58:04 PM

Previous topic - Next topic

kristysmith

I am trying to do a statement for the top 10 slot machines by number FOR location (property), but I cant seem to figure out where to put the ( ). The tip would help if my statement was like their example, but its not.

topcount([RD Detail].[RD Detail].[Slot Machine or Table Seat],10,[Chips/Coins In Amount]for [Location])

the tip says....
aggregate_function(expression FOR expression {,expression})

Any ideas?

sir_jeroen

syntax is:
sum( [Quantity] for [Product Line], [Product Type])

kristysmith

I think you misunderstood my question. I am trying to use the topcount function, to get the top 10, not sum. Thanks though. I was able to make it work.

sir_jeroen

The sum was just an example... It should work for your function too. You asked help for the "FOR" syntax...