Channels
accounting
administration
advancedpdf
announcements
arm
australia
beginners
beta-testers
bundles
case-management
content-alerts
crm-sfa
csvimports
data-privacy
defects
demandplanning
dev-ops
fixed-assets-mgmt
formulas
general
integrations
inventory
italy
jobs
manufacturing
marketing
migration-discussion
multibook
nspb
oneworld
order-to-cash
payroll
performance
procure-to-pay
projects
r-e-networks
random
releases
request-a-channel
scis
scripting
sdf
sfa
sitebuilder
spain
srp
suite-app
suite-billing
suite-people
suiteanalytics
suitebuilder
suitecommerce
suiteflow
suiteql
suitescript
suitetalkapi
suiteworld
taxes
training
upvote-enhancements
women-in-netsuite
Powered by
Title
m
michoel
08/29/2019, 12:30 AM
@pmendola
I think you want Line Sequence Number
p
pmendola
08/29/2019, 2:47 PM
using that field still skips the lines, I was able to get it displayed mostly correctly using case and decode but still not perfect
m
michoel
09/02/2019, 5:54 AM
Just came across this, might help you
https://netsuite.custhelp.com/app/answers/detail/a_id/70844/kw/saved%20search%20kit%20component
Formula(Numeric) | RANK() OVER(PARTITION BY {number} ORDER BY {linesequencenumber})
#suiteanalytics
Join Slack