topic Re: To show percentage in pivot table in App Development

To show percentage in pivot table

Bharathi09 — Wed, 19 Oct 2022 05:40:16 GMT

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

Re: To show percentage in pivot table

justISO — Wed, 19 Oct 2022 06:09:06 GMT

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.

Re: To show percentage in pivot table

Bharathi09 — Wed, 19 Oct 2022 06:26:25 GMT

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

Re: To show percentage in pivot table

justISO — Wed, 19 Oct 2022 06:29:10 GMT

so maybe like this:

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

Re: To show percentage in pivot table

Bharathi09 — Wed, 19 Oct 2022 06:31:25 GMT

Thanks alot, it worked