How calculate the percentage?

[carlos13]

From the Field "ESTRATEGICOS_OBJ_NOMBRE" that has the following values

Calculate the percentage

And I want to get the overall percentage including

But using “sum(total<ESTRATEGICOS_OBJ_NOMBRE,Nombre,IND_NOMBRE> OBJETIVOS_OBJ_PORCENTAJE/100) ” not working

nor with “Avg(total<ESTRATEGICOS_OBJ_NOMBRE,Nombre,IND_NOMBRE> OBJETIVOS_OBJ_PORCENTAJE/100)”

I appreciate any help in advance

I add the example of what I'm working pair to see if I can help.

thanks

[whiteline · Accepted solution]

Don't now if its logicaly right, but I think I've got what you want.

Use this expression:

=avg({$<Nombre={"=Len(Nombre)>0"}>}IF(RSP_CLASE=2,OBJETIVOS_OBJ_PORCENTAJE/100))

And UnCheck 'Supress Zero-Values' on Presentation tab.

[carlos13]

thank