# Optional input for missing values

**URL:** <https://community.velixo.com/t/optional-input-for-missing-values/136>\
**Category:** Ideas & Feature Requests\
**Tags:** Business-Central\
**Created:** [February 11, 2026, 12:12am UTC](https://community.velixo.com/t/optional-input-for-missing-values/136 "2026-02-11T00:12:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chauncey\_Beggs](https://community.velixo.com/letter_avatar_proxy/v4/letter/c/3d9bf3/32.png) [@Chauncey\_Beggs](https://community.velixo.com/u/Chauncey_Beggs)\
**Post date:** [February 11, 2026, 12:12am UTC](https://community.velixo.com/t/optional-input-for-missing-values/136/1 "2026-02-11T00:12:08Z")

</div>

It would be great if you could add an optional input for account value functions (e.g., BC.CLOSINGBALANCE) to specify what to return if a value is missing, such as return 0 rather than an error. This would function the same as [if\_not\_found] in XLOOKUP.

---

<div class="post-metadata">

**Author:** ![Gabriel](https://community.velixo.com/user_avatar/community.velixo.com/gabriel/32/7_2.png) [@Gabriel](https://community.velixo.com/u/Gabriel)\
**Post date:** [May 4, 2026, 8:36pm UTC](https://community.velixo.com/t/optional-input-for-missing-values/136/2 "2026-05-04T20:36:53Z")

</div>

Hi Chauncey,

I missed this post - are you familiar with the “Missing identifier behaviour” in the workbook options? [https://help.velixo.com/doc/main/acumatica/options](https://help.velixo.com/doc/main/acumatica/options)

Do you have a use-case for returning anything other than 0?

Thanks!

---

<div class="post-metadata">

**Author:** ![Chauncey\_Beggs](https://community.velixo.com/letter_avatar_proxy/v4/letter/c/3d9bf3/32.png) [@Chauncey\_Beggs](https://community.velixo.com/u/Chauncey_Beggs)\
**Post date:** [May 11, 2026, 11:20pm UTC](https://community.velixo.com/t/optional-input-for-missing-values/136/3 "2026-05-11T23:20:20Z")

</div>

I missed that option previously. Thanks for pointing it out! Defaulting to zero should work for my purposes.
