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!
Analytics formula field
Hello,
I am trying to create a formula field in my dataset on SuiteAnalytics but i'm not getting the results.
I am wanting a formula field to show projected total when the status is Won.
This is my formula, output type is FLOAT
Case when {status} = 'won' THEN {projectedtotal} ELSE 0 END
I have tried changing 'won' to 'job: closed - won' & 'closed - won'
but it's still not showing any results in my 'won' column.
Would appreciate some help please :)
Many thanks
Nickoletta