Arcade Expression Calculations NaN values

JasonSimpson

I am in the process of creating a field calculation through expression for a popup and keep getting a return of NaN for records that have a zero dollar value in both fields. My expression is as followed. 

Round(($feature["Field1"]/$feature["Field2"])*100,2) + "%"

Is it possible to create return text for all fields that have NaN as the value? I have created return values for fields with null values before, but I am uncertain if fields with NaN is possible. Thanks.  

kenbuja

You could wrap this in an iif to check if the value is zero.

<SPAN class="token function">IIf</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Field2"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">===</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Zero"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token function">Round</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Field1"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="operator token">/</SPAN>$feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Field2"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">*</SPAN><SPAN class="number token">100</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"%"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN><SPAN class=""></SPAN>