{"id":3762,"date":"2017-08-21T14:32:27","date_gmt":"2017-08-21T14:32:27","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-filter-netsuite-saved-searches-using-a-case-when-summary-formula-2\/"},"modified":"2026-07-28T18:26:06","modified_gmt":"2026-07-28T18:26:06","slug":"comment-filtrer-les-recherches-enregistrees-dans-netsuite-a-laide-dune-formule-de-synthese-case-when","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-filtrer-les-recherches-enregistrees-dans-netsuite-a-laide-dune-formule-de-synthese-case-when\/","title":{"rendered":"Comment filtrer les recherches enregistr\u00e9es dans NetSuite \u00e0 l’aide d’une formule de synth\u00e8se CASE WHEN ?"},"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 comment configurer une recherche enregistr\u00e9e dans NetSuite afin d\u2019identifier les enregistrements dans lesquels le nombre de deux types distincts de membres d\u2019\u00e9quipe diff\u00e8re, \u00e0 l\u2019aide d\u2019un filtre de synth\u00e8se.","ga_short_answer":"Pour filtrer une recherche enregistr\u00e9e dans NetSuite en fonction d\u2019une diff\u00e9rence entre deux champs compt\u00e9s, appliquez un filtre de synth\u00e8se. Configurez ce filtre sur \u00ab COUNT - Sup\u00e9rieur \u00e0 0 \u00bb et utilisez une \u00ab Formule (num\u00e9rique) \u00bb avec l\u2019expression suivante : CASE WHEN COUNT({salesteammember}) ! COUNT({partnerteammember}) THEN 1 ELSE 0 END. Cela permet d\u2019identifier les enregistrements dont les nombres ne sont pas \u00e9gaux.","ga_scenario":"Les utilisateurs ont souvent besoin d\u2019identifier dans NetSuite les enregistrements pour lesquels le nombre de membres d\u2019\u00e9quipe associ\u00e9s, issus de diff\u00e9rentes cat\u00e9gories, ne correspond pas. Par exemple, un sc\u00e9nario peut n\u00e9cessiter de rechercher les enregistrements pour lesquels le nombre de membres de l\u2019\u00e9quipe commerciale n\u2019est pas \u00e9gal au nombre de membres de l\u2019\u00e9quipe des partenaires. Cela n\u00e9cessite une recherche enregistr\u00e9e capable de comparer des valeurs agr\u00e9g\u00e9es.","ga_solution":"La solution consiste \u00e0 configurer un filtre \u00ab R\u00e9sum\u00e9 \u00bb<\/a> dans la recherche enregistr\u00e9e de NetSuite. Ce filtre doit \u00eatre configur\u00e9 pour \u00e9valuer une formule qui v\u00e9rifie l\u2019in\u00e9galit\u00e9 entre les nombres d\u2019occurrences des deux champs pertinents relatifs aux membres de l\u2019\u00e9quipe. Ajoutez un nouveau filtre sous l\u2019onglet \u00ab R\u00e9sum\u00e9 \u00bb. D\u00e9finissez les crit\u00e8res de filtrage sur \u00ab COUNT - Sup\u00e9rieur \u00e0 0 \u00bb. Dans le champ \u00ab Formule (num\u00e9rique) \u00bb, saisissez exactement l\u2019expression suivante : `CASE WHEN COUNT({salesteammember}) ! COUNT({partnerteammember}) THEN 1 ELSE 0 END`. Cette configuration garantit que seuls les enregistrements pour lesquels le nombre de membres de l\u2019\u00e9quipe commerciale n\u2019est pas \u00e9gal au nombre de membres de l\u2019\u00e9quipe partenaire sont renvoy\u00e9s par la recherche enregistr\u00e9e.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T16:32:27+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"Saved search with Case scenario","ga_ans_id":"ANS-0103","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":[92],"class_list":["post-3762","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\/3762","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\/3762\/revisions"}],"predecessor-version":[{"id":5683,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3762\/revisions\/5683"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3762"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3762"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3762"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}