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

Advanced Group function

Started by mayocraze, 08 May 2011 08:47:46 PM

Previous topic - Next topic

mayocraze

Hi Experts,

Need your help here. I'm trying to create a report studio report in which I can group certain account numbers together. So for example I have account number 1,2,3,4,5,6,7, I wanna group 1,2,3,4 together and get the sum of them, then 5,6,7 together and get the sum.

Is it possible in report studio? How can I do this?

mayocraze

I tried using both the following two queries, but it returned me no data...

1)
case when
([GL Control Files].[Chart of Accounts].[Account Number])
in ('73100','73120','73130','73140','73150','73515','73525') then ('sals')
else
   case when
([GL Control Files].[Chart of Accounts].[Account Number])
in ('70110','70130','70140','70160','70400') then ('payrolls') end
end

2)
If
([GL Control Files].[Chart of Accounts].[Account Number]
in ('73100','73120','73130','73140','73150','73515','73525')) then ('sals')
else
   if ([GL Control Files].[Chart of Accounts].[Account Number]
in ('70110','70130','70140','70160','70400')) then ('payrolls')
else null

blom0344

Is Account number a string or a numeric value?