Discussion board where members can get started with QlikView.
I have used this below given formula to calculate the percent and added the field as expression in pivot table.
margin/Freight *100 as GM%
So, the calculation is correct for some values only.
The format used is integer and expression is sum(GM%).
PFA screenshot of my pivot where I've marked the wrong values in red and right ones in green.
Are you calculating like this?
margin / (Freight * 100) ???
So, you can play with number format or else please post QVW to test
Using "naked" fields in the front end can lead to unexpected results. Fields in front end expressions should normally be inside an aggregation function of some kind. Perhaps
Sum(margin) / Sum(Freight)
Sum(margin / Freight)
And then use % format to display the values as a $