DIFOT. I'm wanting to make a simple % of Sales Ord...
# suiteanalyticsn
Netsuite Tragic
02/02/2021, 9:43 PMDIFOT. I'm wanting to make a simple % of Sales Orders shipped with 1 Fulfilment / Total Sales Orders. For the numerator I am thinking a Formula (text), COUNT, CASE WHEN COUNT({number})=COUNT({fulfillingtransaction.number}) THEN 'Yes' ELSE null END. this gives the ubiquitous "unexpected error"
k
KevinJ of Kansas
02/02/2021, 9:57 PMI don't think that would work... but I can't figure out a better way to handle it
KevinJ of Kansas
02/02/2021, 9:58 PMthat said - have you tried throwing a nullif around your division so you aren't trying to divide by 0/null?
KevinJ of Kansas
02/02/2021, 9:59 PMYou might have to throw some logic on a saved search field that is pushed to a stored value field via workflow - and then just report off that stored value field.
n
Netsuite Tragic
02/02/2021, 10:05 PMyes, I was thinking the two step stored value field. Ended up with a numerator sum field of CASE WHEN COUNT(DISTINCT({fulfillingtransaction.number})) = 1 THEN 1 ELSE 0 END and for today just gong to read off two values from the bottom of the report.
d
Dominic B
02/03/2021, 11:05 AMDo you just want the data, or do you need to present it in a single search? If it's the former, I'd create two searches and just use summary criteria to search for 1 or more than 1 fulfilment
n
Netsuite Tragic
02/03/2021, 12:47 PMWas hoping to have it in a single Summary search. Actually you have given me an idea. I can use the two searches and calculate it through a KPI Dashboard.