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!
Suiteanalytics summarize calculated measure with a max value being used
I have a calculated measure on my SA workbook. consists of both a max value and a sum value, but on the grand total it just shows the max of that field. I want that to show the summary though.
In general, the use case for this is I have forecast records that I'm wanting to access from a sales order SA pivot table and want to access then sum properly given the correct date context on the pivot table.
E.g. below
Planned Amount (Max) is a formula field that is basically finding the forecast that matches the item and customer and if that forecast has the correct month it pulls in the forecast number, else it is 0