set analesys with distinc

[Anonymous]

hi,

i have this formula :

count

count(DISTINCT([profilenum]))

i need to count profilenum just when i have value in feild [stopkod]

how i need to write it ?

count(DISTINCT(<{[stopkod]>0}>[profilenum])) - wrong i think.

thanks'

yarin.

[alexandros17]

if stopkod is numeric then try this

Count({$ <stopkod={'>0'}>} distinct profilenum)

[israrkhan]

Hi,

Try This

Count({<ProfileNum={"Stopkod"}> Distinct ProfileNum })

Hope this help.

[Gysbert_Wassenaar · Accepted solution]

Try: count(DISTINCT {<[stopkod]={'*'}>}[profilenum])

[Anonymous]

thanks'

yarin.