Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I got one problem with counting a quantity of fields.
I need to simply count the number of projects. As shown in the example, I choose 105 projects. But the result of "Count(Projekt)" leads to 369 projects, what might be the result of some double (or more) countings because of different sources, that may lead to this result.
Is there a possibility to figure out the result, that is reperesented by the selection on the upper left? In best case I want to define this result as a variable to do further work with it as displaying avarage project-value and else.
Thanks for your help in advance.
Regards
Tom Müller
try
count(distinct Projekt)
Am i missing something? Count(DISTINCT Projekt) should work for you.
That's it, thank you!
Works, thanks a lot!