# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
Contributor II

## Calculate percentual of percentuals

I have the following situation:

I need to calculate a percentual according number of itens, on this case: (100%+80%+100%)/3 = 93,33%.
Tx de Sucesso = Num(Sum([MET.VL_REAL]) / Sum([MET.VL_PLAN]),'##0,0%')
If I simple divide this total formula by 3 the result is 30%.

Labels (1)
• ### Qlik Sense

1 Solution

Accepted Solutions

Maye be :

``=Num(avg(Realized/Plnanned),'##0,0%')``

output for 3:

for 4 values :

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
6 Replies

and for ?

``Num(Avg(aggr(Sum([MET.VL_REAL]) / Sum([MET.VL_PLAN]),VIplan,ViAju, VLreal)),'##0,0%')``

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Contributor II
Author

Hello @Taoufiq_Zarra

Does not works yet (Tx S2)

Hello @ecacarva

can you share a sample data ? and the expected result ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Contributor II
Author

The result must be 93,33% that is (100+80+100) / 3.
3 record :
1st reaches 100%
2nd reached 80%
3rd  reached 100%

280%/3=93,33%

If have 4 records then divided to 4

Maye be :

``=Num(avg(Realized/Plnanned),'##0,0%')``

output for 3:

for 4 values :

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Contributor II
Author

Dear @Taoufiq_Zarra

It works, I used the field '%META' that was my break on list:

Num(Avg(aggr(Sum([MET.VL_REAL]) / Sum([MET.VL_PLAN]),[%META])),'##0,0%')

Thank you very much !

Tags
Community Browser