Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
i face an issue with some KPI's in sheet , some of them not shows any values
the formula i used in GA,BoD, Meetings:
sum({<Flag = {'Governance'},[KPI Name] = {'GA, BoD, Committees meetings'}>}Actual)
/
sum({<Flag = {'Governance'},[KPI Name] = {'GA, BoD, Committees meetings'}>}Plan)
Thank You
try this:
sum({<Flag = {'Governance'},[KPI Name] = {'GA','BoD','Committees meetings'}>}Actual)
/
sum({<Flag = {'Governance'},[KPI Name] ={'GA','BoD','Committees meetings'}>}Plan)
by the way - if my original suggestion does not work then it is something with your data or data model.
cheers
thank you