Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a KPI object but it gives me too many projects. I noticed that there are several projects without any year connected
to it when I put the expression in a straight table. I want to eliminate the project that don't have a year.
How can I write an expression like Count(distinct Projectnumber) and eliminate those without year in a KPI object?
Hi Stephanie,
Maybe you can check-out "Zero Values" or use Count(Distintc {<Ar={"*"}>}Projeknummer)
Regards
Miguel del Valle
I can't check out null values because I have values.
I tried your expression but it didn't give me the correct answer.
Hi Stephanie,
Could you attach an data example?
I don´t understand you so well,
Regards
Miguel del Valle
I get 2 435 in the KPI object when using your expression. I should be getting 4 117.
Can you use calculated dimension something like
if (getpossiblecount(year>0,Project)