This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi, i have two fields one is ref number and the other is amount:

Ref No:   Amount:
1.              $10
1.              $20
2.              $10
3.              $50

How can output so it will say 

Ref No:     Amount:
1.               $30
2.               $10
3.               $50

Thanks!!