Calculating percentage

[Lucky1]

Hi I have to show my values in percentage

My Dimention is product

my measure is

count({<Flag={0}, Closed_QuarterSerial= {"$(=Maxstring([Closed_QuarterSerial])-1)"}>}Item_Id)

I have used expression to calculate % like below but iam getting wrong numbers

count({<Flag={0}, Closed_QuarterSerial= {"$(=Maxstring([Closed_QuarterSerial])-1)"}>}Item_Id)

/

count(Total {<Flag={0}, Closed_QuarterSerial= {"$(=Maxstring([Closed_QuarterSerial])-1)"}>}Item_Id)

Please help me on this

[MartW]

@Lucky1 , when you are in editmode please go to the table and change the numberformating to percentage.

Qlik will automatically change this to percentages.

[Lucky1]

Hi MartW,

i have selected % but it is giving wrong percentage

[Lucky1]

Hi MartW,

Iam calculating percentage for my previous quarter sales. for Totals it should show 100% and for Access/entitlements it should show 0.00 (26/23465) 

for - nulls it should show 97%(22994/23465)  but it is showing wrong numbers