Count Distinct

[#1]

Hi

count

(distinct {$<Kalender.Kalender.Jahr={$(=Only(Kalender.Kalender.Jahr))}>} Billing_Header.Billing_Header.SalesDoc_ID

)

I'm trying to get a count of no of unice SelesDoc_ID using set analysis but i become more count as row number

Thanks

Shideh

[yblake]

I don't understand your formula ???

the test value = only(value) is always true in a table with value as dimension .

why not using

count(distinct if(invoice_year=$(yy_input),invoice_id,null())

the yy_input is a variable you can input, or define i.e. as year(reloaddate()).