Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
I'm trying to use kpi that measure sum of governance fields for which company have that name ,
but it keep show errors
if({<[Company Name] = {'KC'}>} , sum $(vGovernance_Maturity_Level)+ $(vCompleted_Polices_Charter)+ $(vConflict_Intrest)+ $(vDOA_Matrix)+ $(vLegal_Documentation)+ $(vDisclosure_Transparecy)+ $(vAnnual_Board_Report) / 😎
thank you
Try this
Sum(
{<[Company Name] = {'KC'}>}
(
$(vGovernance_Maturity_Level) +
$(vCompleted_Polices_Charter) +
$(vConflict_Intrest) +
$(vDOA_Matrix) +
$(vLegal_Documentation) +
$(vDisclosure_Transparecy) +
$(vAnnual_Board_Report
)
)
)
thank you