What Data format is needed to get correct percent values in Pivot table chart.

[Anonymous]

Hi,

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.

Thanks

[Anil_Babu_Samineni]

Are you calculating like this?

margin / (Freight * 100) ???

[Anonymous]

No, (margin/freight) * 100.

[techvarun]

Use margin/Freight in the expression and format the field like below

[Anil_Babu_Samineni]

So, you can play with number format or else please post QVW to test

[Anonymous]

I want to divide with the value in the freight column so count(freight) work right?

[techvarun]

Yeah, It will work

[jonathandienst]

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)

     or

     Sum(margin / Freight)

Use Aggregation Functions!

And then use % format to display the values as a $

[Anonymous]

Tried this, but values r same as that in the screenshot.

[techvarun]

Share  sample data to work