Running Total formula in Netsuite Saved Search is duplicating each row

I am using the SUM OVER PARTITION formula in Netsuite transaction saved search to get the running total of item quantity.

SUM /* comment */ {quantity} OVER(PARTITION BY {item} ORDER BY {trandate} ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)

The formula works but it duplicates each row as shown below. Each transaction # of the item appears twice here

Any advise on how can I correct this?

Rookie Asked on April 27, 2023 in Saved Searches.
Add Comment
1 Answer(s)

try using transaction saved search and main line false

Advanced Answered on May 2, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor