Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have this colum N° Doc and it show me 96 documents in total, i want it show me the number of document im selecting
im using this expression, obviously wrong i guess =count(total distinct [Num.Doc])&'N° Doc', can you help me to fix it?
@Xolink1389 Since you want to count only number of document that you need, you can try without Total.
=count(distinct [Num.Doc])&'N° Doc'
La réponse suggérée par @Anil_Babu_Samineni est correcte.
Je me permet de la modifier pour une questions d'esthétique.
=count(distinct [Num.Doc])&' N° Doc'
(Ajoute de l'espace)
Je l'ai essayé de mon côté, et cela fonctionne convenablement.
Cordialement,
Théo ATRAGIE.
didnt work either
with distinct
Votre champ saisi est bien une dimension?
Saisissez [Num.Doc] en champ, et la formule suggérait par @Anil_Babu_Samineni en expression d'étiquette de celle-ci.
Cordialement,
Théo ATRAGIE.
@Xolink1389 When you say it doesn't work, What is not working? If you can explain that we can think and offer something that you will expect.
when i say it dont work, i mean that it doesnt count correctly, i used the code you recommend and instead show me the amount im selecting in the case of the image are 2 num. of documents, its show me more, like it counting more documents in the column or table, it show me the 2 when i selected de row, but i dont want to select the rows, i need it read them by them self alone.
like you can see the number on the top is 118 but im not selecting the row and the columsm it may have something with the fact im selecting another column as a filter?
when i selected lib.mayor it show me 2 documents but in the top of the tags dont show me the rigth number of the docs
Can you share the .qvf ?
Maybe you can try this :
=count({$}Distinct [Num.Doc])&' N° Doc'