Enquiry on difference between rows

[#1]

Dear fellow experts,

I have a table like this which is loaded in the script

Field                         Location          YTD     Month     Budget

Turnover                    Japan               100     20               110

Gross margin             Japan                 40     10               50

Operating profit          Japan                 10     2                 20            

Turnover                    India                1000     500               1100

Gross margin             India                 600         200               750

Operating profit          India                    300     100               350

I will like to show operating expense as difference between Operating profit and gross margin in a straight table.

Is this possible? Bearing in mind that my table is pretty huge with a few hundred rows as there are more than 2 locations as in the example above.

[pokassov]

Hello!

When you add field "Field" it's used for join.

In the same time values in fields (t1 and "left join to t1") are different.

So you have joined null values for Field, Loaction, ...Budget2

When after that you try to calculate different between YTD and YTD2 (which is null), you would take null...

Sergey