We have a long formula which returns an integer wh...
# suiteanalyticsn
Netsuite Tragic
05/03/2022, 9:44 AMWe have a long formula which returns an integer which will project forward a date field. When I have [formula] + {today} it works. Edit the formula [formula] + {lastorderdate} which is a valid, native date field on Customer the search immediate returns "An unexpected error has occurred. Please click here to notify support and provide your contact information." I used the {today} example to prove up that the formula works and returns the value as expected. I have tried wrapping TO_DATE({lastorderdate}). Any ideas?
Netsuite Tragic
05/03/2022, 9:46 AMCASEWHEN COUNT(DISTINCT CASE WHEN {transaction.trandate} > LAST_DAY(ADD_MONTHS({today}, -14)) AND {transaction.trandate} <= LAST_DAY(ADD_MONTHS({today}, -1)) THEN CASE WHEN {transaction.type}='Invoice' THEN {transaction.number} ELSE NULL END ELSE NULL END)>35 THEN 7 ELSE 90 END + {lastorderdate}g
George McMullen
05/03/2022, 10:50 AMPerhaps it’s the mix between an aggregation (COUNT) and {lastorderdate}? Does the formula have a summary type on it?
George McMullen
05/03/2022, 10:52 AMYou could try one of the following.
• Add an aggregation to
{lastorderdate}MIN({lastorderdate})COUNT(COUNT/*comment*/(George McMullen
05/03/2022, 10:53 AMOr maybe there is a null value in one of the records for
{lastorderdate}NVL()n
Netsuite Tragic
05/03/2022, 9:06 PM@George McMullen thanks for the aggregate reminder. It didn't work. I made the formula result a custom field with an update script and moved on.