Saved Search Formula Using Trunc and Add_Months to Show Last Month

Formula (Currency) | Summary Type: Sum | decode(trunc({‌trandate},’month’),trunc(add_months({‌today},-1),’month’),{‌amount},0) | Custom Label:  Last Month

Leave a comment

Your email address will not be published. Required fields are marked *