Value group by KPI

[#1]

Hi mates!

I got this table:

DATO	KPI	VAL DATO	VAL KPI
D.001	D.001.K1	99,2205%	98,4679%
D.001	D.001.K1	99,2205%	98,4679%
D.001	D.001.K1	99,2205%	98,4679%
D.001	D.001.K1	99,2205%	98,4679%
D.001	D.001.K2	99,2205%	100,0000%
D.001	D.001.K2	99,2205%	100,0000%
D.001	D.001.K4	99,2205%	98,9989%
D.001	D.001.K4	99,2205%	98,9989%
D.001	D.001.K4	99,2205%	98,9989%
D.001	D.001.K4	99,2205%	98,9989%
D.001	D.001.K5	99,2205%	100,0000%
D.001	D.001.K5	99,2205%	100,0000%
D.001	D.001.K5	99,2205%	100,0000%
D.001	D.001.K6	99,2205%	-
D.001	D.001.K6	99,2205%	-
D.001	D.001.K6	99,2205%	-
D.001	Gar_5	99,2205%	-

Now I´m getting VAL DATO as the average of all values of VAL KPI (without null values).

I want to get the average of these values by KPI (without null values), the table will be like this:

DATO	KPI	VAL DATO	VAL KPI
D.001	D.001.K1	99,3667%	98,4679%
D.001	D.001.K1	99,3667%	98,4679%
D.001	D.001.K1	99,3667%	98,4679%
D.001	D.001.K1	99,3667%	98,4679%
D.001	D.001.K2	99,3667%	100,0000%
D.001	D.001.K2	99,3667%	100,0000%
D.001	D.001.K4	99,3667%	98,9989%
D.001	D.001.K4	99,3667%	98,9989%
D.001	D.001.K4	99,3667%	98,9989%
D.001	D.001.K4	99,3667%	98,9989%
D.001	D.001.K5	99,3667%	100,0000%
D.001	D.001.K5	99,3667%	100,0000%
D.001	D.001.K5	99,3667%	100,0000%
D.001	D.001.K6	99,3667%	-
D.001	D.001.K6	99,3667%	-
D.001	D.001.K6	99,3667%	-
D.001	Gar_5	99,3667%	-

Thank you very much guys!!

[Gysbert_Wassenaar]

Try avg({<[Val KPI]={">0"}>}total [Val KPI])

[#3]

Thank you Gysbert,

Sorry but I'm trying to do it on Script, is it possible?

Thanks again.