Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Subtraction in pivot table or straight table

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.

PnLExp.png

3 Replies
MVP
MVP

Re: Subtraction in pivot table or straight table

Hi,

Try this expression

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

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: Subtraction in pivot table or straight table

Hi Jagan,

Thanks for your reply. But unfortunately its not working.

Is there any other way to achieve this.

Not applicable

Re: Subtraction in pivot table or straight table

Hi,

Try :

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

Regards

RL

Community Browser