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

I'm a little beginner in oracle sql I have a saved search that runs a  query
```qty sold   DECODE({item.memberquantity},NULL,{quantity},{quantity}*{item.memberquantity})     stock    DECODE({item.quantityonhand},NULL,{quantity},{quantity}*{item.quantityonhand})   ```
My manager wants to add this stock  minus qty sold  in one column  then column 2  take that answer divide by 12 how can I save the answer in a variable so it won't run 3 times

You will have to repeat the formula for each column

or what about combine inside the decode statement

Nah that's not going to affect query speed in any noticeable way

I'm not sure what you mean about combine inside the decode statement, but personally I would rewrite the decode as `{quantity} * NVL({item.memberquantity}, 1)`

<https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions040.htm>