Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a column name "active" and fields are "True" and "False". Now I want create a KPI as "No of Active projects".
There are 75 - True and False - 25.
So I need out put in KPI as 75.
Please can any help me out how can we write expression.
@Balujyothi4 wrote:
Hi
I have a column name "active" and fields are "True" and "False". Now I want create a KPI as "No of Active projects".
There are 75 - True and False - 25.
So I need out put in KPI as 75.
Please can any help me out how can we write expression.
Assuming that you can count no of project by the expression Count(ProjectID), make adjustments to my suggestion to fit your data.
Num(Count({<Active={'True'}>}ProjectID)/count(ProjectID),'0%')
@Balujyothi4 wrote:
Hi
I have a column name "active" and fields are "True" and "False". Now I want create a KPI as "No of Active projects".
There are 75 - True and False - 25.
So I need out put in KPI as 75.
Please can any help me out how can we write expression.
Assuming that you can count no of project by the expression Count(ProjectID), make adjustments to my suggestion to fit your data.
Num(Count({<Active={'True'}>}ProjectID)/count(ProjectID),'0%')
Think you so much vegar, its worked