{"id":3722,"date":"2022-01-11T17:31:29","date_gmt":"2022-01-11T17:31:29","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-count-distinct-values-in-a-netsuite-saved-search-summary-formula-2\/"},"modified":"2026-07-28T18:26:04","modified_gmt":"2026-07-28T18:26:04","slug":"comment-compter-les-valeurs-distinctes-dans-une-formule-de-synthese-de-recherche-enregistree-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-compter-les-valeurs-distinctes-dans-une-formule-de-synthese-de-recherche-enregistree-netsuite\/","title":{"rendered":"Comment compter les valeurs distinctes dans une formule de synth\u00e8se de recherche enregistr\u00e9e NetSuite ?"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"Les utilisateurs de NetSuite peuvent garantir l'exactitude des rapports agr\u00e9g\u00e9s en appliquant correctement le mot-cl\u00e9 \u00ab distinct \u00bb dans les champs de formule de synth\u00e8se.","ga_short_answer":"Pour ne compter que les valeurs uniques dans un champ de formule de synth\u00e8se d\u2019une recherche enregistr\u00e9e NetSuite, ajoutez le mot-cl\u00e9 \u00ab distinct \u00bb directement avant le nom du champ dans la formule. Cela garantit que le comptage regroupe les enregistrements uniques plut\u00f4t que chaque ligne individuelle, ce qui permet d\u2019obtenir des r\u00e9sultats de synth\u00e8se pr\u00e9cis.","ga_scenario":"Lors de la cr\u00e9ation d\u2019une recherche enregistr\u00e9e NetSuite comportant un d\u00e9compte r\u00e9capitulatif<\/a> dans un champ de formule, les utilisateurs peuvent constater que ce d\u00e9compte refl\u00e8te le nombre de lignes individuelles plut\u00f4t que le nombre de valeurs uniques. Par exemple, un d\u00e9compte cens\u00e9 afficher le nombre de \u00ab lignes de commande \u00bb uniques peut afficher \u00e0 tort un total incluant des lignes en double, ce qui indique que chaque ligne est comptabilis\u00e9e au lieu des entr\u00e9es distinctes.","ga_solution":"Pour ne compter que les enregistrements uniques dans un champ de formule r\u00e9capitulatif, ajoutez le mot-cl\u00e9 `distinct` directement avant le champ \u00e0 compter.","ga_source_author":"Rosemary (silu) Zeng","ga_source_author_email":"","ga_date_original":"2022-01-11T09:31:29-08:00","ga_date_verified":"2026-07-05","ga_source_subject":"Saved Search: Use 'distinct' in Summary Count formula field","ga_ans_id":"ANS-0063","ga_publish_decision":"publish","ga_staleness_risk":"medium","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3722","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-administrateur-netsuite","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":91,"label":"Recherches enregistr\u00e9es et formules"},{"value":3,"label":"Saved Searches & Formulas"},{"value":91,"label":"Recherches enregistr\u00e9es et formules"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":92,"label":"Niveau interm\u00e9diaire"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3722","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3722\/revisions"}],"predecessor-version":[{"id":5643,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3722\/revisions\/5643"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3722"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3722"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3722"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}