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

There are two rows in the result of a search which are shown using a formula, I want show a result in third row by applying a formula on first two rows/results of same saved search??

you then need to create a formula containing the other formulas.

Hi <@UN6AWH96Y> How I can create a formula which contains other formulas?

copy it and insert it inside the other formula

like:

case when a &lt; b then 0 else 1 end

case when x &lt; y then case when a &lt; b then 0 else 1 else 1 end

<@UER9Q3SGM> I mean row in result of saved search when it is edit mode but it is a column I'm actually talking about!

<@UN6AWH96Y> I want to calculate the margin % of these two amounts which I have been calculating using these two FORMULA(CURRENCY) so I want to use these two Formula(Currency) in the last row and calculate the % of amount from it!!!!

so you have a search with two results (two rows), and in one of the columns you have a formula(currency).

now you want display a third row with a margin % of that column.
is this correct?

Yeah right!.. I want to use those other two columns and show the margin in third using a formula

so row or column? one can be done the other can not as far as i know.

arh, i see what you mean. it is added like a row in edit mode.

you need to use formula(numeric) where you define the formula that calculates the margin. then you copy the two other formulas into it.