{"id":3766,"date":"2019-05-09T19:41:52","date_gmt":"2019-05-09T19:41:52","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-do-netsuite-saved-search-absolute-value-functions-differ-with-sum-2\/"},"modified":"2026-07-28T18:26:06","modified_gmt":"2026-07-28T18:26:06","slug":"en-quoi-les-fonctions-de-valeur-absolue-des-recherches-enregistrees-dans-netsuite-different-elles-de-la-fonction-somme","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/en-quoi-les-fonctions-de-valeur-absolue-des-recherches-enregistrees-dans-netsuite-different-elles-de-la-fonction-somme\/","title":{"rendered":"En quoi les fonctions de valeur absolue des recherches enregistr\u00e9es dans NetSuite diff\u00e8rent-elles de la fonction SOMME ?"},"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 explique le fonctionnement des calculs de valeur absolue dans les recherches enregistr\u00e9es de NetSuite lorsque vous utilisez un type de synth\u00e8se \u00ab SUM \u00bb.","ga_short_answer":"Dans les recherches enregistr\u00e9es de NetSuite, l'utilisation de l'op\u00e9rateur ABS() dans une formule avec un type de synth\u00e8se \u00ab SUM \u00bb calcule la somme des valeurs absolues (avant agr\u00e9gation). Le comportement du menu d\u00e9roulant de la fonction \u00ab Valeur absolue \u00bb avec \u00ab SUM \u00bb pour la valeur absolue post-agr\u00e9gation n\u2019est pas explicitement confirm\u00e9 et peut \u00e9galement entra\u00eener une pr\u00e9-agr\u00e9gation.","ga_scenario":"Les utilisateurs ont souvent besoin de calculer la valeur absolue de donn\u00e9es financi\u00e8res ou quantitatives dans le cadre des recherches enregistr\u00e9es de NetSuite. Une source fr\u00e9quente de confusion survient lorsqu\u2019ils tentent d\u2019additionner ces valeurs, notamment quant \u00e0 savoir si la valeur absolue doit \u00eatre appliqu\u00e9e avant ou apr\u00e8s l\u2019addition, selon la m\u00e9thode choisie.","ga_solution":"Lors de la configuration d\u2019une recherche enregistr\u00e9e NetSuite avec un type de synth\u00e8se \u00ab SUM \u00bb, la m\u00e9thode utilis\u00e9e pour appliquer les valeurs absolues a un impact significatif sur le r\u00e9sultat du calcul. Lorsque \u00ab<a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-apply-advanced-filtering-with-summary-formulas-in-netsuite-saved-searches\/\">Type de synth\u00e8se = SUM<\/a>\n\u00bb est s\u00e9lectionn\u00e9 et que la fonction \u00ab Valeur absolue \u00bb est choisie dans le menu d\u00e9roulant d\u2019une colonne, la documentation actuelle de NetSuite ne pr\u00e9cise pas explicitement si le syst\u00e8me calcule la valeur absolue de la somme (c\u2019est-\u00e0-dire la valeur absolue du r\u00e9sultat, apr\u00e8s agr\u00e9gation). D\u2019apr\u00e8s les principes g\u00e9n\u00e9raux r\u00e9gissant l\u2019application des fonctions aux colonnes dans NetSuite, cette m\u00e9thode pourrait appliquer la valeur absolue \u00e0 chaque enregistrement avant de les additionner, \u00e0 l\u2019instar de l\u2019op\u00e9rateur ABS(). En revanche, lorsque l\u2019option \u00ab Type de synth\u00e8se = SOMME \u00bb est s\u00e9lectionn\u00e9e et que l\u2019op\u00e9rateur ABS() est utilis\u00e9 dans une formule, NetSuite calcule syst\u00e9matiquement la somme des valeurs absolues. Cela signifie que chaque valeur individuelle est d\u2019abord convertie en valeur absolue, puis que ces valeurs absolues sont additionn\u00e9es. Par exemple, un champ de formule pourrait se pr\u00e9senter comme suit :\n```\nABS({amount})\n```\nDans ce sc\u00e9nario, si les valeurs d\u2019origine \u00e9taient -10, 5, -3, l\u2019op\u00e9rateur ABS() les convertirait d\u2019abord en 10, 5, 3, puis le type de synth\u00e8se \u00ab SUM \u00bb donnerait 18.","ga_source_author":"Jean-Mathieu Rose","ga_source_author_email":"","ga_date_original":"2019-05-09T12:41:52-07:00","ga_date_verified":"2026-07-05","ga_source_subject":"In a saved search, what's the difference between using the 'Absolute Value' function and the 'ABS()' operator in a formula when summary type is SUM?","ga_ans_id":"ANS-0107","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The claim that 'Summary type = SUM and Function = Absolute Value' results in the 'absolute value of the sum' (i.e., absolute value of the result) is not explicitly confirmed by current NetSuite documentation. While the 'Absolute Value' function exists and 'SUM' summary type exists, the interaction to produce a post-aggregation absolute value is not clearly documented as distinct from a pre-aggregation absolute value.","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3766","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\/3766","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\/3766\/revisions"}],"predecessor-version":[{"id":5687,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3766\/revisions\/5687"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3766"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3766"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3766"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3766"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}