{"id":4380,"date":"2017-08-21T15:14:40","date_gmt":"2017-08-21T15:14:40","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-calculer-des-ratios-financiers-dans-netsuite-a-laide-dindicateurs-cles-de-performance-kpi-et-de-recherches-enregistrees\/"},"modified":"2026-07-28T18:26:42","modified_gmt":"2026-07-28T18:26:42","slug":"comment-calculer-des-ratios-financiers-dans-netsuite-a-laide-dindicateurs-cles-de-performance-kpi-et-de-recherches-enregistrees","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-calculer-des-ratios-financiers-dans-netsuite-a-laide-dindicateurs-cles-de-performance-kpi-et-de-recherches-enregistrees\/","title":{"rendered":"Comment calculer des ratios financiers dans NetSuite \u00e0 l&rsquo;aide d&rsquo;indicateurs cl\u00e9s de performance (KPI) et de recherches enregistr\u00e9es"},"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 exploiter les \u00e9crans de KPI et les recherches enregistr\u00e9es pour obtenir des indicateurs de performance financi\u00e8re essentiels.","ga_short_answer":"Les ratios financiers peuvent \u00eatre calcul\u00e9s dans NetSuite \u00e0 l\u2019aide des \u00e9crans KPI et des recherches enregistr\u00e9es. Pour les ratios complexes tels que le BPA (b\u00e9n\u00e9fice par action) ou le taux de distribution, des comptes statistiques peuvent \u00eatre n\u00e9cessaires. Des formules personnalis\u00e9es peuvent \u00eatre mises en \u0153uvre au sein des recherches enregistr\u00e9es afin d\u2019effectuer des calculs sp\u00e9cifiques de pourcentages et de ratios, y compris la gestion de la division par z\u00e9ro.","ga_scenario":"Les organisations ont souvent besoin de calculer divers ratios financiers pour \u00e9valuer leurs performances, tels que la rentabilit\u00e9, la liquidit\u00e9 et l\u2019efficacit\u00e9. Bien que certains indicateurs standard soient disponibles, des ratios sp\u00e9cifiques ou personnalis\u00e9s peuvent n\u00e9cessiter des calculs sur mesure au sein de NetSuite. Cela implique souvent de combiner diff\u00e9rentes donn\u00e9es financi\u00e8res et de g\u00e9rer les erreurs potentielles li\u00e9es \u00e0 la division par z\u00e9ro.","ga_solution":"Les ratios financiers peuvent \u00eatre calcul\u00e9s dans NetSuite \u00e0 l\u2019aide de deux m\u00e9thodes principales : les \u00e9crans KPI et les recherches enregistr\u00e9es. Pour les ratios avanc\u00e9s tels que le b\u00e9n\u00e9fice par action (BPA) ou le taux de distribution, la cr\u00e9ation de comptes statistiques pour des indicateurs tels que le nombre d\u2019actions en circulation peut s\u2019av\u00e9rer n\u00e9cessaire.\n\nPour <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-create-a-custom-kpi-for-gross-margin-percentage-in-netsuite\/\">les calculs personnalis\u00e9s de pourcentages et de ratios<\/a>\n\n, les recherches enregistr\u00e9es offrent la flexibilit\u00e9 n\u00e9cessaire pour d\u00e9finir des formules sp\u00e9cifiques. Vous trouverez ci-dessous des exemples de formules pouvant \u00eatre utilis\u00e9es dans les recherches enregistr\u00e9es de NetSuite, illustrant comment calculer des pourcentages, g\u00e9rer la division par z\u00e9ro et effectuer des sommes conditionnelles :\n\nPourcentage\/ratio avec gestion de la division par z\u00e9ro et somme conditionnelle :\n```\n(SUM(CASE WHEN {account}'440050 Culling of Bins' THEN {Amount} ELSE 0 END)*-1)\/nullif(SUM(CASE WHEN {accounttype}'Income' THEN {Amount} ELSE 0 END),0)\n```\n\nSomme des comptes de produits :\n```\nSUM(CASE WHEN {accounttype}'Income' THEN {Amount} ELSE 0 END)\n```\n\nSomme d\u2019un compte sp\u00e9cifique :\n```\nSUM(CASE WHEN {account}'440050 Culling of Bins' THEN {Amount} ELSE 0 END)\n```\n\nRatio des heures suppl\u00e9mentaires par rapport \u00e0 la masse salariale totale :\n```\nsum(case when {account} '611010 Overtime' then {Amount} else 0 end)\/nullif(sum(CASE WHEN {account} '611000 Wages' THEN {Amount} ELSE 0 END),0)\n```\n\nRatio de quantit\u00e9s arrondies (par exemple, exp\u00e9di\u00e9es par rapport \u00e0 command\u00e9es) :\n```\nRound(SUM(NVL({quantityshiprecv},0)) \/ NULLIF(SUM(NVL({quantity},0)),0),2)\n```","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:14:40-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"How to get various financial ratios?","ga_ans_id":"ANS-0721","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Financial Reporting","footnotes":""},"ga_category":[33,110,110],"ga_audience":[9],"ga_difficulty":[92],"class_list":["post-4380","qa_entry","type-qa_entry","status-publish","hentry","ga_category-financial-reporting","ga_category-rapports-financiers","ga_audience-finance-accounting-team","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":33,"label":"Financial Reporting"},{"value":110,"label":"Rapports financiers"},{"value":110,"label":"Rapports financiers"}],"ga_audience":[{"value":9,"label":"Finance\/accounting team"}],"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\/4380","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\/4380\/revisions"}],"predecessor-version":[{"id":6301,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/4380\/revisions\/6301"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=4380"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=4380"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=4380"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=4380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}