Hi all
Quick question. I am trying to work out a percentage on a netsuite saved search.
Each member of the sales team has a target for the number of unique accounts they are trading with each month.
I want to work out the percentage of this I have achieved.
I am setting the Formula to Numeric and the Summary type to MAX and then using this formula:
CASE WHEN {salesrep} = 'XXXXX' THEN COUNT({custcol_2663_companyname})/'30' ELSE NULL END
The name of the custom field above is the customers company name. My logic is to COUNT these up, then divide by 30 to get the percentage.
However this formula results in
"An unexpected error has occurred."
Does anyone know what I am doing wrong here?
Thank you
Kind regards
Oliver