Calculate percentual of percentuals

[ecacarva]

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%.

[Taoufiq_Zarra]

@ecacarva 

and for ?

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

[ecacarva]

Hello @Taoufiq_Zarra

Does not works yet (Tx S2)

[Taoufiq_Zarra]

Hello @ecacarva 

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

[ecacarva]

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

[Taoufiq_Zarra · Accepted solution]

Maye be :

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

output for 3:

for 4 values :

[ecacarva]

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 !