{"id":3690,"date":"2017-08-21T15:02:35","date_gmt":"2017-08-21T15:02:35","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-calculate-gross-profit-percentage-in-netsuite-reports-2\/"},"modified":"2026-07-28T18:26:02","modified_gmt":"2026-07-28T18:26:02","slug":"comment-calculer-le-pourcentage-de-marge-brute-dans-les-rapports-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-calculer-le-pourcentage-de-marge-brute-dans-les-rapports-netsuite\/","title":{"rendered":"Comment calculer le pourcentage de marge brute dans les rapports 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":"Ce guide pr\u00e9sente la formule NetSuite permettant de calculer le pourcentage de marge brute, en mettant l'accent sur l'agr\u00e9gation correcte des donn\u00e9es relatives aux revenus et aux co\u00fbts.","ga_short_answer":"Pour calculer le pourcentage de marge brute dans NetSuite, assurez-vous que tous les \u00e9l\u00e9ments de recettes et de co\u00fbts sont additionn\u00e9s. La formule prend en charge les cas o\u00f9 les recettes sont nulles afin d\u2019\u00e9viter les erreurs de division ; elle renvoie alors 0 dans ces cas-l\u00e0, et calcule sinon (somme des recettes - somme des co\u00fbts) \/ somme des recettes.","ga_scenario":"Les utilisateurs ont souvent besoin d\u2019afficher le pourcentage de marge brute dans les rapports NetSuite ou dans des champs personnalis\u00e9s. L\u2019un des d\u00e9fis courants consiste \u00e0 s\u2019assurer que les donn\u00e9es financi\u00e8res sous-jacentes, notamment les chiffres relatifs aux revenus et aux co\u00fbts, sont correctement agr\u00e9g\u00e9es avant d\u2019effectuer le calcul du pourcentage, ce qui peut entra\u00eener des r\u00e9sultats erron\u00e9s si cette \u00e9tape n\u2019est pas g\u00e9r\u00e9e correctement.","ga_solution":"Pour calculer avec pr\u00e9cision le pourcentage de marge brute dans NetSuite, il est essentiel de s\u2019assurer que tous les \u00e9l\u00e9ments de recettes et de co\u00fbts pertinents sont correctement additionn\u00e9s. Pour ce faire, veuillez utiliser la formule suivante, qui int\u00e8gre une v\u00e9rification de l\u2019existence d\u2019une recette nulle afin d\u2019\u00e9viter les erreurs de division :\n\n```\nCASE WHEN\n  {income}  0\nTHEN\n  0\nELSE\n  (SUM({income}) - SUM({cost})) \/ SUM({income})\n```\n\n. Cette formule v\u00e9rifie tout d\u2019abord si le total des recettes est \u00e9gal \u00e0 z\u00e9ro. Si c'est le cas, le pourcentage de marge brute est d\u00e9fini sur 0. Dans le cas contraire, elle calcule ce pourcentage en soustrayant la somme des co\u00fbts de la somme des recettes, puis en divisant le r\u00e9sultat par la somme des recettes.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T17:02:35+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"formula of a Gross Profit %","ga_ans_id":"ANS-0031","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],"ga_difficulty":[93],"class_list":["post-3690","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-debutant"],"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":93,"label":"D\u00e9butant"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3690","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\/3690\/revisions"}],"predecessor-version":[{"id":5611,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3690\/revisions\/5611"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3690"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3690"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3690"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}