Sum if

[#1]

I need to make a sum for different options.

Example:

The order for account A is 10. We have failed to deliver 1, which is marked as "failed". (in the tabel 2 rows, commom dimensions are accountnr and ordernr)

The order for account B is 100. We have delivered all.

I need the following result:

                    Ordered     Delivered     Not delivered

Account A     10               9               1

Account B     100          100               0

How can I proceed? Best to use Rowno or Recno? Or something else?

Thanks!

[Jason_Michaelides]

Please provide example of the input data.

[#3]

Customer	Ordered/ delivered	Article	Date	Amount
Customer A	Ordered	105	26-sep-12	1
Customer A	Not delivered	105	26-sep-12	-1
Customer B	Ordered	105	26-sep-12	1
Customer B	Not delivered	105	26-sep-12	-1
Customer C	Ordered	105	26-sep-12	1
Customer C	Not delivered	105	26-sep-12	-1
Customer D	Ordered	105	26-sep-12	1
Customer D	Not delivered	105	26-sep-12	-1
Customer E	Ordered	105	26-sep-12	1
Customer E	Not delivered	105	26-sep-12	-1
Customer F	Ordered	105	26-sep-12	1
Customer F	Not delivered	105	26-sep-12	-1
Customer G	Ordered	105	26-sep-12	1
Customer G	Not delivered	105	26-sep-12	-1
Customer H	Ordered	105	26-sep-12	1
Customer H	Not delivered	105	26-sep-12	-1

[#4]

Here you go

[rajni_batra]

What output do u want??? no. of products deliverd/Not delivered?? do u have any field regarding that??

[Jason_Michaelides]

Where do you get the number ordered from in there?

[#7]

The output I need is in the following format:

Customer     Amount ordered     Amount not delivered

Customer A          1                    -1

Customer B          1                    -1

Customer C          1                    -1

So the second line per customer needs to be added to the first line. In this example it's only 2 lines per customer, but it can be more.

[#8]

The output I need is in the following format:

Customer     Amount ordered     Amount not delivered

Customer A          1                    -1

Customer B          1                    -1

Customer C          1                    -1

So the second line per customer needs to be added to the first line. In this example it's only 2 lines per customer, but it can be more.

[#9]

The output I need is in the following format:

Customer     Amount ordered     Amount not delivered

Customer A          1                    -1

Customer B          1                    -1

Customer C          1                    -1

So the second line per customer needs to be added to the first line. In this example it's only 2 lines per customer, but it can be more.

[#10]

The output I need is in the following format:

Customer     Amount ordered     Amount not delivered

Customer A          1                    -1

Customer B          1                    -1

Customer C          1                    -1

So the second line per customer needs to be added to the first line. In this example it's only 2 lines per customer, but it can be more.