Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Saved Search date formula help needed
Hi guys,
I have created a saved search to show bank account balances at the end of the past 3 months. a column for the current balance, one for the balance at the last day of last month, one for the last day of the month before and one for the last day of the month before that.
My first column is just a sum of all posting transactions on the bank account. This is fine.
My second column uses the following formula and works fine - Formula (currency) / Sum / case when {trandate} <= LAST_DAY(TRUNC({today}, 'MONTH')-1) then {amount} else 0 end