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

Multiple calculation in single data item need ti display

Started by srinu_anu2007, 24 Aug 2012 12:19:40 AM

Previous topic - Next topic

srinu_anu2007

Hi,

I have report item called Male , i need to display below requirement in single column.
cn any one suggest, i can write all calculation as a single but need to display all in one item.

"The count of male members under the age of <1,1,2-6,7-13...)
Count of member number  where gender is male and  difference between birthdate and currentdate"

HalfBloodPrince

#1
Try this
For displaying first two count  create calculation in query, then add a text item into the list, then click on unlock button , then add text item and query calculation into that text item as per your requirement. I have not understood the last requirement .

other way is after creating a calculated column for counts, create one more query calculation like this 'count of male members '+ cast([Count of age range],varchar(4)) +' '+ 'Count of Males' + cast([Count of Male],varchar(4))

even calculation can also be done in this column also , but i am not sure what your exact report requirement eg.
'No of Males' + cast(count ([age]),varchar(4))