i need a formula to get the amounts of account end date is today and gets back to the same day of last mont

AI generated answer (using internal Slack threads):

Based on the conversations provided, it seems like you are trying to calculate the amount for a specific account where the end date is today and goes back to the same day of the last month. In NetSuite, you can use a saved search to achieve this. You can create a new saved search for the specific account and set the criteria to filter the transactions where the date is between today and the same day of the last month. Here is a sample formula you can use in the criteria:

Formula (Date): {trandate} BETWEEN add_months({today}, -1) AND {today}

This formula will filter the transactions where the transaction date (

trandate

) is between today and the same day of the last month. Then, in the results tab, you can add a new column to calculate the sum of the amount for these transactions. Here is a sample formula you can use:

Formula (Numeric, sum): {amount}

This formula will calculate the sum of the amount for the transactions that meet the criteria. Please note that you might need to adjust these formulas based on your specific requirements and the actual fields used in your account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******