# Parameter skip if empty

**URL:** <https://www.epiusers.help/t/parameter-skip-if-empty/47938>\
**Category:** Epicor ERP 10\
**Created:** [September 19, 2018, 1:48pm UTC](https://www.epiusers.help/t/parameter-skip-if-empty/47938 "2018-09-19T13:48:38Z")\
**Posts on this page:** 8\
**Page:** 2

<div class="post-metadata">

**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\
**Post date:** [September 19, 2018, 3:05pm UTC](https://www.epiusers.help/t/parameter-skip-if-empty/47938/21 "2018-09-19T15:05:54Z")

</div>

Try 0(8)?

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [September 19, 2018, 3:07pm UTC](https://www.epiusers.help/t/parameter-skip-if-empty/47938/22 "2018-09-19T15:07:03Z")

</div>

No joy…

![image](https://epiusers.help/uploads/default/original/2X/3/3a183f56099dcfdeb96a1267fd28490620a0debc.png)

---

<div class="post-metadata">

**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\
**Post date:** [September 19, 2018, 3:08pm UTC](https://www.epiusers.help/t/parameter-skip-if-empty/47938/23 "2018-09-19T15:08:02Z")

</div>

It lets you type it, but does it get mad when you click OK?

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [September 19, 2018, 3:08pm UTC](https://www.epiusers.help/t/parameter-skip-if-empty/47938/24 "2018-09-19T15:08:54Z")

</div>

yeah, type mismatch. Same if it’s x(8). If I put a number in there, I just get a warning that there could be a type mismatch, but it works.

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [September 19, 2018, 3:18pm UTC](https://www.epiusers.help/t/parameter-skip-if-empty/47938/25 "2018-09-19T15:18:26Z")

</div>

1. Make the Param an Int, with default value = -1

2. Add two table criteria with the field \>= expression and the field \<= expression  
 ![image](https://epiusers.help/uploads/default/original/2X/b/bef11232415ae1d99d4106b02ac605f1dd8c103d.png)

3. The expressions should be:  
`(case when @TestParam = -1 then -1 else @TestParam end)` for “\>=”  
`(case when @TestParam = -1 then 9999999999 else @TestParam end)` for “\<=”

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [September 19, 2018, 3:20pm UTC](https://www.epiusers.help/t/parameter-skip-if-empty/47938/26 "2018-09-19T15:20:28Z")

</div>

What about null? (back to the calculated field thing?)

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [September 19, 2018, 3:22pm UTC](https://www.epiusers.help/t/parameter-skip-if-empty/47938/27 "2018-09-19T15:22:03Z")

</div>

Do you know of any tables of the top of your head that have an integer column that can be null? Just asking so I can do some testing against.

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [September 19, 2018, 3:25pm UTC](https://www.epiusers.help/t/parameter-skip-if-empty/47938/28 "2018-09-19T15:25:49Z")

</div>

no, I don’t. It’s only null because of a left join in the BAQ.

[Previous page](https://www.epiusers.help/t/parameter-skip-if-empty/47938.md?page=1)