Hi All.
please help me how to keep count of custom...
# suitescripts
suryaprakash598
04/04/2020, 8:57 AMHi All.
please help me how to keep count of customers in a location in formula
'<a href="#" >'||COUNT({internalid})||'</a>'
Where i am getting result as invalid Expression
Thanks
b
battk
04/04/2020, 2:17 PMyou can try using
COUNT ({internalid}) OVER ()battk
04/04/2020, 2:19 PMtrying to use analytic functions causes enough weird behaviors that i would recommend using alternatives first
battk
04/04/2020, 2:20 PMin this case, potentially use summaries in your columns or use a paged search to get the count of results
s
suryaprakash598
04/04/2020, 2:30 PMThanks @battk
i tried with count as summary in that case i am unable to get hyper link
suryaprakash598
04/04/2020, 2:31 PMis there any way to get hyper link on using count as summary in formula
b
battk
04/04/2020, 2:36 PMbasically the formula you originally had with a minimum or maximum summary