How to read columns in Table?

[#1]

Hi,

I got a table as below where I got a "ORDER" and "RECEIVED" column. I want to calculate "RECEIVED" column  received plus "ORDER" columns rows "RECEIVED =  0". please find the table and columns to be calculated below. Thanks! in advance.

DATE	ORDER	RECEIVED
Apr-12	2,437,701	2,433,701
May-12	3,462,796	3,4502796
Jun-12	3,293,204	3,200,204
Jul-12	4,537,285	4,537,285
Aug-12	3,347,838	0
Sep-12	3,302,835	0
Oct-12	3,035,546	0
Nov-12	2,995,542	0
Dec-12	3,170,730	3,170,730
Jan-13	3,081,588	3,081,588

[#2]

Hi ,

Try like this,

=if(RECEIVED = 0,ORDER,0)+sum(RECEIVED)

Thanks

Saurabh

[#3]

Hi,

pls find the sample attached qvw which may be the solution for your req as per my understandigs.

[CELAMBARASAN]

Hi,

Try this

=Sum(RECEIVED) + Sum({<RECEIVED={0}>}ORDER)

[#5]

Hi all,

Please find the attachment below. I guess YTD and Last Year YTD are wrong.

according to the budget I want see YTD. Please help me...

[MarcoWedel]

=If(Received,Received, Order)

[MarcoWedel]

Hi,

one solution:

hope this helps

regards

Marco

[MarcoWedel]

or

hope this helps

regards

Marco