<div>
You can use a Ternary expression - like so<br />
<br />

<pre><code id="code-20-41914775-1">necResult= QTYCostWithSalesRev_180DayCOGS ? (QTYCostWithSalesRev_180DayCOGS*2)/(SERVER_FLD0000003) : 0</code></pre>
<br />
Basically the same as<br />
<br />

<pre><code id="code-20-41914775-2">if (QTYCostWithSalesRev_180DayCOGS) {
  necResult =  (QTYCostWithSalesRev_180DayCOGS*2)/(SERVER_FLD0000003) ;
}
else {
  necResult = 0;
}</code></pre>
</div>


You can use a Ternary expression - like so



necResult= QTYCostWithSalesRev_180DayCOGS ? (QTYCostWithSalesRev_180DayCOGS*2)/(SERVER_FLD0000003) : 0


Basically the same as



if (QTYCostWithSalesRev_180DayCOGS) {
  necResult =  (QTYCostWithSalesRev_180DayCOGS*2)/(SERVER_FLD0000003) ;
}
else {
  necResult = 0;
}

<div>
There is no closed replacement, cause CASE in SQL (at least T-SQL) has two different forms..<br />
<br />
One is the <a href="https://developer.mozilla.org/en/docs/Web/JavaScript/Reference/Statements/switch" rel="ugc">switch</a> statement. The other form is a cascading <a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Statements/if...else" rel="ugc">if .. else if</a>.<br />
<br />
Please define 'blank' in your context.
</div>


There is no closed replacement, cause CASE in SQL (at least T-SQL) has two different forms..

One is the switch [https://developer.mozilla.org/en/docs/Web/JavaScript/Reference/Statements/switch] statement. The other form is a cascading if .. else if [https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Statements/if...else].

Please define 'blank' in your context.

<div>
@Ste5an<br />
I mean 0 not blank.<br />
<br />
I would you write the SWITCH code?
</div>


@Ste5an
I mean 0 not blank.

I would you write the SWITCH code?

<div>
@isames,<br />
<br />
Do you still require assistance with this question? If so post back here, otherwise please can you close the question.<br />
<br />
JulianH
</div>


@isames,

Do you still require assistance with this question? If so post back here, otherwise please can you close the question.

JulianH

<div>
<div class="content wysiwyg-content">
How do you write the equivalent of a SQL Case expression in JavaScript?<br />
<br />
Below is what I have so far:<br />
necResult=(QTYCostWithSale<wbr />sRev_180Da<wbr />yCOGS*2)/(<wbr />SERVER_FLD<wbr />0000003);<br />
<br />
The above code works, but I need to add to the code that says, 'when QTYCostWithSalesRev_180Day<wbr />COGS is 'blank' or zero, then zero else execute the code above.
</div>
</div>


How do you write the equivalent of a SQL Case expression in JavaScript?

Below is what I have so far:
necResult=(QTYCostWithSalesRev_180DayCOGS*2)/(SERVER_FLD0000003);

The above code works, but I need to add to the code that says, 'when QTYCostWithSalesRev_180DayCOGS is 'blank' or zero, then zero else execute the code above.

Javascript Case Expression

JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and  in almost every mainstream web browser.