{"id":3697,"date":"2017-08-21T14:53:23","date_gmt":"2017-08-21T14:53:23","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-get-the-last-amount-by-date-in-a-grouped-netsuite-saved-search-2\/"},"modified":"2026-07-28T18:26:02","modified_gmt":"2026-07-28T18:26:02","slug":"comment-obtenir-le-dernier-montant-par-date-dans-une-recherche-enregistree-groupee-de-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-obtenir-le-dernier-montant-par-date-dans-une-recherche-enregistree-groupee-de-netsuite\/","title":{"rendered":"Comment obtenir le dernier montant par date dans une recherche enregistr\u00e9e group\u00e9e 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":"Apprenez \u00e0 extraire le montant le plus r\u00e9cent \u00e0 partir de donn\u00e9es regroup\u00e9es dans une recherche enregistr\u00e9e NetSuite \u00e0 l'aide d'un champ de formule sp\u00e9cifique.","ga_short_answer":"Pour obtenir le dernier montant par date dans une recherche enregistr\u00e9e group\u00e9e, ajoutez une option de regroupement sur le champ \u00ab Type \u00bb. Ajoutez ensuite un champ de formule \u00e0 la liste des r\u00e9sultats avec un type de synth\u00e8se \u00ab Maximum \u00bb. Utilisez la formule Max({montant}) KEEP(DENSE_RANK LAST ORDER BY {date_de_cr\u00e9ation}) pour r\u00e9cup\u00e9rer la valeur souhait\u00e9e.","ga_scenario":"Les utilisateurs sont souvent confront\u00e9s \u00e0 des situations o\u00f9 ils doivent r\u00e9cup\u00e9rer le montant le plus r\u00e9cent associ\u00e9 \u00e0 une date sp\u00e9cifique au sein d\u2019une <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-achieve-multiple-level-grouping-in-netsuite-saved-searches\/\">recherche enregistr\u00e9e group\u00e9e dans NetSuite<\/a>. Les fonctions de regroupement standard ne fournissent pas n\u00e9cessairement directement la derni\u00e8re valeur en fonction d\u2019un champ de date, ce qui n\u00e9cessite une formule sp\u00e9cialis\u00e9e pour extraire cette information avec pr\u00e9cision.","ga_solution":"Pour obtenir le dernier montant par date dans une recherche enregistr\u00e9e group\u00e9e, commencez par ajouter une option de groupe suppl\u00e9mentaire sur le champ `Type`. Ajoutez ensuite un champ de formule \u00e0 la liste des r\u00e9sultats. Ce nouveau champ doit avoir le type de synth\u00e8se `Maximum` s\u00e9lectionn\u00e9. Enfin, saisissez la formule suivante dans le champ de formule : `Max({amount}) KEEP(DENSE_RANK LAST ORDER BY {datecreated})`.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:53:23-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Get the last date amount in a Saved Search that use group","ga_ans_id":"ANS-0038","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":[94],"class_list":["post-3697","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-avance"],"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":94,"label":"Avanc\u00e9"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3697","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\/3697\/revisions"}],"predecessor-version":[{"id":5618,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3697\/revisions\/5618"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3697"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3697"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3697"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}