Row Subtraction in Table

[#1]

Hi friends,

I have this table

Type	Batting	Bowling
A	44.4	47.4
B	8.4	8.8
C	1.3	1.8
D	1.3	1.7
E	6.8	7.6
F	3.9	3.8
Total 1	62.2	67.4
G	8.0	8.2
Total 2	70.2	75.6

The field highlighted in bold , Row E i want the value Row F - Row E, so the total comes correct in Total 1.

Can you please tell me how to deal with row subtraction?

Regards,

KC

[fvelascog72]

Hi,

I hope I understand your requeriments.

See attached file.

[#3]

Hi Federico,

Thanks for your quick response.

But the values highlighted in bold, Row E is still showing 6.8 and i want Row F - Row E (6.8-3.9 = 2.9)  for batting

For bowling (7.6-3.8 = 3.8) and everything on the table remains same.

Regards,

KC

[#4]

Hi,

I am not sure whether column subtraction like col(3)-col(2) works in case of rows as well.

Regards,

KC

[sunny_talwar · Accepted solution]

Try these expressions:

Batting: =Sum(Batting) - If(Type = 'E', sum(TOTAL {<Type = {'F'}>}Batting), 0)

Bowling: =Sum(Bowling) - If(Type = 'E', sum(TOTAL {<Type = {'F'}>} Bowling), 0)

Output:

I used the sample that was prepared by fvelascog72 and made slight changes to it

Best,

Sunny

[#6]

Hey Thanks Sunindia,

This is perfect!

Regards,

KC

[sunny_talwar]

No problem

I am glad I was able to help.

Best,

Sunny