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: KPI Scorecard (w/ custom record)
I have a custom record w/ field date, backorder amt.
ex.
5/12/2014 10k
5/15/2014 15k
5/16/2014 12k
I am trying to build a saved search for my kpi scorecard.
that will tell me the backorder amount for last week.
kpi scorecard last week should be 12k.
KPI scorecard will only calculate 1 column, so grouping will not work for the scorecard.
It must have a summary type, or it will automatically just do a count of the results. (in this case, it would be 3).
so i have to choose MAX, MIN, SUM, AVG.
i don't see how i can display amt 15k with those summary types & only using 1 column.