Count and NODISTINCT

[#1]

I don't understand which kind of formula I must use and how to write it...I must count the number of suppliers and even if they are repeated, they must be counted! in the file I use

count([Ragione Sociale Fornitore])

but this formula gives me 15 instead of 18 (since 3 suppliers are repeated). How can I get 18???

Please find the file attached

[alexandros17 · Accepted solution]

Sono riuscito a scaricare il documento:

ecco l'espressione che ti serve ...

Sum(Aggr(count( [Ragione Sociale Fornitore]), [Numero Documento]))

fammi sapere

[#3]

Grazie mille Alessandro Saccone!!!!!! non riuscivo proprio a capire dove sbagliassi...grazie!!