# Math Formula Result 0 if no value

**URL:** <https://forum.knime.com/t/math-formula-result-0-if-no-value/20334>\
**Category:** KNIME Analytics Platform\
**Created:** [January 8, 2020, 3:23am UTC](https://forum.knime.com/t/math-formula-result-0-if-no-value/20334 "2020-01-08T03:23:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![andersenyunan](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/a/cab0a1/32.png) [@andersenyunan](https://forum.knime.com/u/andersenyunan)\
**Post date:** [January 8, 2020, 3:23am UTC](https://forum.knime.com/t/math-formula-result-0-if-no-value/20334/1 "2020-01-08T03:23:13Z")

</div>

Hi, is there any way I could add conditional formula in KNIME math formula (multi column) node for results to be 0 instead of ‘?’

I’m trying to perform joiner node for table after this but since the value of ‘?’ is too much in certain row it’s creating issue as what I read in here [Joiner node is locked at 60](https://forum.knime.com/t/joiner-node-is-locked-at-60/6269/2)

![image](https://forum-cdn.knime.com/uploads/default/original/2X/c/cb9538b5572224014ef3f320aa93710ff3e4c329.png)

Thanks!

---

<div class="post-metadata">

**Author:** ![andersenyunan](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/a/cab0a1/32.png) [@andersenyunan](https://forum.knime.com/u/andersenyunan)\
**Post date:** [January 8, 2020, 4:19am UTC](https://forum.knime.com/t/math-formula-result-0-if-no-value/20334/2 "2020-01-08T04:19:53Z")

</div>

My joiner node started at 30% and progress very slowly for the past 1 H to 41% although I already edit the results to 0

![image](https://forum-cdn.knime.com/uploads/default/original/2X/8/869d5816ecf2cbefd5dbec579638ca8397b7f7e9.png)

---

<div class="post-metadata">

**Author:** ![morpheus](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/ce73a5/32.png) [@morpheus](https://forum.knime.com/u/morpheus)\
**Post date:** [January 8, 2020, 9:57am UTC](https://forum.knime.com/t/math-formula-result-0-if-no-value/20334/3 "2020-01-08T09:57:38Z")

</div>

Hi @andersenyunan,

did you checked your Math Formula data. It looks like you do a n:m joining which produces x duplicate result rows. This could be the reason for slowing down your process.

For changing missing values into 0 you can use the missing value node.

> **[Missing Value — NodePit](https://nodepit.com/node/org.knime.base.node.preproc.pmml.missingval.compute.MissingValueHandlerNodeFactory)**
>
> Filters or replaces missing values in a table.

BR Hermann

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [July 8, 2020, 9:57pm UTC](https://forum.knime.com/t/math-formula-result-0-if-no-value/20334/4 "2020-07-08T21:57:41Z")

</div>

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.