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

[avinashelite]

Hi Mafaz,

Can you please elaborate your requirement and please post your app. 

[its_anandrjs]

Can you elaborate more please not understood clearly.

[vardhancse]

what exactly you are trying to achieve.

Receive+orders where received=0

[PrashantSangle]

Hi,

What is your actual requirement?

As per my understanding, You want

Order + Received when Received=0

If this is your requirement then try like

If(Received=0,Order,Received)

If this is not requirement then plz elaboarate with your required Output.

Regards,

[settu_periasamy]

find the below attachment

[#7]

Jaufer

can you be more specific in your question

[#8]

guys what I want is... I have ordered some goods. its in the "ORDER" column

and within those orders I have received some goods. those are in "RECEIVED" column

what I exactly want is I want to see the YTD of  my budget. which means what I have received +  what I'am about to receive.

PLEASE FIND THE COLOURED VALUES IN THE TABLE. I WANT TO "SUM" THOSE VALUES.....

[ashfaq_haseeb]

For Received

=sum(RECEIVED)

For Ordered

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

For clubbing all together try below

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

Regards

ASHFAQ

[PrashantSangle]

Hi,

Simply try with,

if(Received=0,Sum(Ordered),Sum(Received))

Regards