Print Page - HOW TO ADD THE TWO COLUMS IN SINGLE PAGE

Title: HOW TO ADD THE TWO COLUMS IN SINGLE PAGE
Post by: ravinagabhaskar on 19 Nov 2007 01:26:55 AM

This is ravi

my request is .
one report has orderyear,ordermonth,revenue.
I Want one more column (calucalted) that is sum of order yearand period number.

order year order month order year+month revenue
2004 1 200401 xxxxxxx
2004 2 200402 xxxxxxxxx
.
.
2004 12 200412 xxxxxxxx

How to add the two colume as my request

help me pls

Title: Re: HOW TO ADD THE TWO COLUMS IN SINGLE PAGE
Post by: MFGF on 19 Nov 2007 04:58:23 AM

Hi,

How about a query calculation - ([Order year] * 100) + [Order month]

Regards,

MF.

Title: Re: HOW TO ADD THE TWO COLUMS IN SINGLE PAGE
Post by: trevorp on 06 Dec 2007 04:47:07 AM

Hi

Think you need to concatenate the 2 fields [order year]||[order month], therefor

2004 and 12 = 200412. You might need to do something with the missing leading zero on months 1 to 9

Title: Re: HOW TO ADD THE TWO COLUMS IN SINGLE PAGE
Post by: chow on 10 Dec 2007 09:24:42 AM

use concatenate( !! )funtion to add 2 field

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ravinagabhaskar on 19 Nov 2007 01:26:55 AM