Subtraction in pivot table or straight table

[#1]

Hi,

In my report, one of the field is getting calculated based on the subtraction of two fields. Please check the attached screen shot "PnLExp", here i want to calculate "Gross margin".

Formula is  Gross margin = Total Direct Labor Cost - Total Other Direct Cost

How i can achieve this, in pivot or straight table; pls. help.

[jagan]

Hi,

Try this expression

=Sum(Total Direct Labor Cost) - Sum(Total Other Direct Cost)

Hope this helps you.

Regards,

Jagan.

[#3]

Hi Jagan,

Thanks for your reply. But unfortunately its not working.

Is there any other way to achieve this.

[#4]

Hi,

Try :

aggr(Sum(Total Direct Labor Cost) - Sum(Total Other Direct Cost),Pnt_Parent)

Regards

RL