{"id":2495,"date":"2017-08-21T15:28:20","date_gmt":"2017-08-21T15:28:20","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-calculer-les-pourcentages-des-colonnes-recapitulatives-dans-les-recherches-enregistrees-de-netsuite\/"},"modified":"2026-07-28T18:26:01","modified_gmt":"2026-07-28T18:26:01","slug":"comment-calculer-les-pourcentages-des-colonnes-recapitulatives-dans-les-recherches-enregistrees-de-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-calculer-les-pourcentages-des-colonnes-recapitulatives-dans-les-recherches-enregistrees-de-netsuite\/","title":{"rendered":"Comment calculer les pourcentages des colonnes r\u00e9capitulatives dans les recherches enregistr\u00e9es de 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":"D\u00e9couvrez comment calculer correctement des indicateurs exprim\u00e9s en pourcentage \u00e0 partir de donn\u00e9es agr\u00e9g\u00e9es issues des recherches enregistr\u00e9es dans NetSuite, en utilisant des structures de formules sp\u00e9cifiques.","ga_short_answer":"Pour calculer les pourcentages des colonnes agr\u00e9g\u00e9es dans les recherches enregistr\u00e9es de NetSuite, utilisez les constructions SUM(CASE WHEN ... THEN {Montant} ELSE 0 END) tant pour le num\u00e9rateur que pour le d\u00e9nominateur. Cette approche garantit que l\u2019agr\u00e9gation a lieu avant la division, ce qui permet d\u2019obtenir des r\u00e9sultats de pourcentage pr\u00e9cis pour les donn\u00e9es agr\u00e9g\u00e9es, tout en g\u00e9rant les \u00e9ventuelles erreurs de division par z\u00e9ro.","ga_scenario":"Les utilisateurs rencontrent souvent des difficult\u00e9s lorsqu\u2019ils tentent de calculer un pourcentage \u00e0 partir de deux colonnes agr\u00e9g\u00e9es dans une recherche enregistr\u00e9e NetSuite. Bien que les pourcentages des lignes individuelles puissent sembler corrects, le simple fait d\u2019additionner ces pourcentages dans une vue agr\u00e9g\u00e9e conduit \u00e0 des r\u00e9sultats inexacts. Cela se produit g\u00e9n\u00e9ralement parce que le <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-do-netsuite-saved-search-absolute-value-functions-differ-with-sum\/\">calcul du pourcentage doit s\u2019effectuer sur les totaux agr\u00e9g\u00e9s<\/a>, et non sur les lignes individuelles avant l\u2019agr\u00e9gation.","ga_solution":"Pour calculer avec pr\u00e9cision les pourcentages des colonnes agr\u00e9g\u00e9es, l\u2019agr\u00e9gation doit s\u2019effectuer au sein m\u00eame de la formule, avant la division. Cela implique d\u2019utiliser <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-apply-advanced-filtering-with-summary-formulas-in-netsuite-saved-searches\/\">SUM(CASE WHEN ... THEN {Montant} ELSE 0 END)<\/a> tant pour le num\u00e9rateur que pour le d\u00e9nominateur. Il est \u00e9galement essentiel d\u2019int\u00e9grer la fonction NULLIF afin d\u2019\u00e9viter les erreurs de division par z\u00e9ro. Vous trouverez ci-dessous des exemples de formules illustrant cette approche : (SUM(CASE WHEN {account}'440050 Culling of Bins' THEN {Amount} ELSE 0 END)*-1)\/nullif(SUM(CASE WHEN {accounttype}'Income' THEN {Montant} ELSE 0 END), 0) SUM(CASE WHEN {compte}'440050 Tri des bacs' THEN {Montant} ELSE 0 END) sum(case when {compte} '611010 Heures suppl\u00e9mentaires' then {Montant} else 0 end)\/nullif(sum(CASE WHEN {compte} '611000 Salaires' THEN {Montant} SINON 0 FIN), 0) Arrondir(SOMME(NVL({quantit\u00e9 exp\u00e9di\u00e9e\/re\u00e7ue}, 0)) \/ NULLIF(SOMME(NVL({quantit\u00e9}, 0)), 0), 2)","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:28:20-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Taking a % of Summary Columns","ga_ans_id":"ANS-0019","ga_publish_decision":"publish","ga_staleness_risk":"high","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,89],"ga_difficulty":[92,92],"class_list":["post-2495","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"},{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":92,"label":"Niveau interm\u00e9diaire"},{"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\/2495","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\/2495\/revisions"}],"predecessor-version":[{"id":2515,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2495\/revisions\/2515"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2495"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2495"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2495"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}