{"id":3730,"date":"2017-08-21T14:55:23","date_gmt":"2017-08-21T14:55:23","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-calculate-rolling-12-month-sales-in-netsuite-saved-searches-2\/"},"modified":"2026-07-28T18:26:04","modified_gmt":"2026-07-28T18:26:04","slug":"comment-calculer-le-chiffre-daffaires-sur-12-mois-glissants-dans-les-recherches-enregistrees-de-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-calculer-le-chiffre-daffaires-sur-12-mois-glissants-dans-les-recherches-enregistrees-de-netsuite\/","title":{"rendered":"Comment calculer le chiffre d&rsquo;affaires sur 12 mois glissants 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":"Utilisez les formules de recherche enregistr\u00e9es de NetSuite pour calculer de mani\u00e8re dynamique le total des donn\u00e9es de vente sur des p\u00e9riodes glissantes, y compris les cumuls depuis le d\u00e9but de l'ann\u00e9e en cours et de l'ann\u00e9e pr\u00e9c\u00e9dente.","ga_short_answer":"Pour calculer le chiffre d\u2019affaires sur 12 mois glissants dans les recherches enregistr\u00e9es de NetSuite, utilisez des formules CASE WHEN sp\u00e9cifiques. Ces formules \u00e9valuent les dates de transaction par rapport \u00e0 une fen\u00eatre de 12 mois glissants et additionnent le champ \u00ab montant \u00bb. Des formules distinctes sont fournies pour le chiffre d\u2019affaires cumul\u00e9 de l\u2019ann\u00e9e en cours et celui de l\u2019ann\u00e9e pr\u00e9c\u00e9dente, garantissant ainsi une analyse pr\u00e9cise des p\u00e9riodes historiques et actuelles.","ga_scenario":"Les utilisateurs de NetSuite ont souvent besoin de rapports dynamiques sur les performances commerciales sur des p\u00e9riodes glissantes, telles que les 12 derniers mois. Cela implique de cr\u00e9er une recherche enregistr\u00e9e capable d\u2019agr\u00e9ger avec pr\u00e9cision les donn\u00e9es de vente, en distinguant les chiffres cumul\u00e9s depuis le d\u00e9but de l\u2019ann\u00e9e en cours de ceux des ann\u00e9es pr\u00e9c\u00e9dentes. La difficult\u00e9 r\u00e9side dans l\u2019\u00e9laboration des formules appropri\u00e9es pour d\u00e9finir ces p\u00e9riodes glissantes au sein des crit\u00e8res de recherche.","ga_solution":"Pour calculer le chiffre d\u2019affaires sur 12 mois glissants dans une recherche enregistr\u00e9e NetSuite, utilisez les formules suivantes. Ces formules sont con\u00e7ues pour additionner les montants des ventes en fonction de crit\u00e8res de date sp\u00e9cifiques, permettant ainsi de calculer \u00e0 la fois le cumul glissant depuis le d\u00e9but de l\u2019ann\u00e9e en cours et le cumul glissant depuis le d\u00e9but de l\u2019ann\u00e9e pr\u00e9c\u00e9dente. Chiffre d\u2019affaires cumul\u00e9 glissant depuis le d\u00e9but de l\u2019ann\u00e9e en cours : `CASE WHEN {custbody_bus_days_period_to_date} < {custbody_current_period.custrecord_bus_days_period_to_date} AND {trandate} < {today}AND {trandate} > ADD_MONTHS({today},-12)THEN {amount} ELSE 0 END` Chiffre d\u2019affaires cumul\u00e9 glissant depuis le d\u00e9but de l\u2019ann\u00e9e pr\u00e9c\u00e9dente : `CASE WHEN {custbody_bus_days_period_to_date} < {custbody_current_period.custrecord_bus_days_period_to_date} AND {trandate} <\u00adD_MONTHS( {today},-12) AND {trandate} > ADD_MONTHS({today},-24)THEN {amount} ELSE 0 END`","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T16:55:23+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"How to do a sum of rolling 12 months sales in saved search","ga_ans_id":"ANS-0071","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-3730","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\/3730","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\/3730\/revisions"}],"predecessor-version":[{"id":5651,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3730\/revisions\/5651"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3730"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3730"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3730"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}