Discussions
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
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
Leaderboard
Community Whiz
Quarter 1 (Jan-Mar 2025)
1
Divya Unnikrishnan
5 Points
2
Hormese Paul
5 Points
3
Diniya A J
5 Points
4
Vairamuthu M
4 Points
5
Mel H
3 Points
6
Angela Bayliss
3 Points
7
Honey Soe
3 Points
8
Manu Antony Vadassery
3 Points
9
Vernita
3 Points
10
Chelsea Jacobs
2 Points
11
Able Wilson
2 Points
12
OliverOO
1 Point
13
Amanda Edwards
1 Point
14
Veda chalam Mahadevan
1 Point
15
Alexis Atrizco
1 Point
16
Jordon F
1 Point