To show percentage in pivot table

[Bharathi09]

Hi All,

I'm creating pivot table in QS.

I need to get percentage for certain field

There is error while creating percentage for model

Count([CI Master ID])/Sum(([CI Master ID]))* 100....I used this expression but it's showing null values

The field I need to use inside is CI Master ID

Please help in creating percentage

Thanks

[justISO]

Hi, try to find where is a problem by dividing your expression into parts and see are they both provide result. 

Count([CI Master ID]) probably will work. If Sum([CI Master ID]) will give you nothing, maybe its needed to be converted to number with Sum(Num([CI Master ID]))?

Additionally, rather than *100, use number formatting as number and choose percentage.

[Bharathi09]

No sum is giving zero

Actually I need to show like Model count/Totals * 100

For example for one row one model count is 9 and Total model model count is 20543 and *100 then it gives 0.04%
Like this I wanna show percentage for every model

[justISO · Accepted solution]

so maybe like this:

Count([CI Master ID])/Count(Total [CI Master ID])

[Bharathi09]

Thanks alot, it worked