topic Subtraction in pivot table or straight table in QlikView

Subtraction in pivot table or straight table

Fri, 05 Oct 2012 06:17:02 GMT

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.

Re: Subtraction in pivot table or straight table

jagan — Fri, 05 Oct 2012 11:16:32 GMT

Hi,

Try this expression

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

Hope this helps you.

Regards,

Jagan.

Re: Subtraction in pivot table or straight table

Mon, 08 Oct 2012 07:39:40 GMT

Hi Jagan,

Thanks for your reply. But unfortunately its not working.

Is there any other way to achieve this.

Re: Subtraction in pivot table or straight table

Mon, 08 Oct 2012 08:41:53 GMT

Hi,

Try :

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

Regards