I am new to Netsuite. I have two columns which I want to subtract from each other and cannot figure out how to do it. The first column is the following:
Case when {linesequencenumber} <> 0 then -nvl({quantity},0) else null end
The second column is the following:
case when {linesequencenumber} = 0 then -nvl({custbody25},0)*nullif(-nvl({quantity},0),0) else null end
Any help anyone can provide would be greatly appreciated.
I have tried subtracting the two columns and was not successful.
I am new to Netsuite. I have two columns which I want to subtract from each other and cannot figure out how to do it. The first column is the following:
Case when {linesequencenumber} <> 0 then -nvl({quantity},0) else null end
The second column is the following:
case when {linesequencenumber} = 0 then -nvl({custbody25},0)*nullif(-nvl({quantity},0),0) else null end
Any help anyone can provide would be greatly appreciated.
I have tried subtracting the two columns and was not successful.
Share Improve this question edited yesterday General Grievance 4,99838 gold badges37 silver badges56 bronze badges asked yesterday gpaulgpaul 1 New contributor gpaul is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct. 1- 1 This question is similar to: How to reference other columns within a formula field on NetSuite Saved Searches?. If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. – erictgrubaugh Commented yesterday
1 Answer
Reset to default 0AFAIK there's no nice way to reference other formula columns.
See the answer here showing that you need to fully repeat the formulas in the difference column.