Discussion board where members can get started with QlikView.
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.
Try this expression
=Sum(Total Direct Labor Cost) - Sum(Total Other Direct Cost)
Hope this helps you.
Thanks for your reply. But unfortunately its not working.
Is there any other way to achieve this.
aggr(Sum(Total Direct Labor Cost) - Sum(Total Other Direct Cost),Pnt_Parent)