HOW TO ADD THE TWO COLUMS IN SINGLE PAGE

[ravinagabhaskar]

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   

[MFGF]

Hi,

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

Regards,

MF.

[trevorp]

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

[chow]

use concatenate( !! )funtion to add 2 field