KPI Remove Nulls

[pgalvezt]

Hello,

I need to remove the null values in the KPI Object.

I Have a KPI with this Formula.

Sum({<fec_ini={">=01-01-2019"}>}NetWorkDays(fec_ini,fecha_Fin, $(vNWD)))

Thanks!!

[Anil_Babu_Samineni · Accepted solution]

Perhaps this

Sum({<fec_ini={">=01-01-2019"}, FieldName_Null = {"=Len(FieldName_Null)>0"}>}NetWorkDays(fec_ini,fecha_Fin, $(vNWD)))

[pgalvezt]

Perfect !!

Thank You !