# Exclude Null From Rollup

**URL:** <https://community.weweb.io/t/exclude-null-from-rollup/3068>\
**Category:** How do I?\
**Created:** [June 15, 2023, 1:51pm UTC](https://community.weweb.io/t/exclude-null-from-rollup/3068 "2023-06-15T13:51:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![BuildLikePeter](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/buildlikepeter/32/2674_2.png) [@BuildLikePeter](https://community.weweb.io/u/BuildLikePeter)\
**Post date:** [June 15, 2023, 1:51pm UTC](https://community.weweb.io/t/exclude-null-from-rollup/3068/1 "2023-06-15T13:51:37Z")

</div>

I am using the rollup formula to create an array. It is returning null for one of the array values. How can I return the rolled up array without the nulls?

![Screenshot 2023-06-15 at 6.51.07 AM](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/3/3c0445d76b63f6c53a574ad87b47174f946e468f.png)

---

<div class="post-metadata">

**Author:** ![Quentin](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/quentin/32/6_2.png) [@Quentin](https://community.weweb.io/u/Quentin)\
**Post date:** [June 15, 2023, 3:18pm UTC](https://community.weweb.io/t/exclude-null-from-rollup/3068/2 "2023-06-15T15:18:49Z")

</div>

You could use the `filter` formula to check that the value isn’t `null`, which will give you a cleaned array

---

<div class="post-metadata">

**Author:** ![jaredgibb](https://avatars.discourse-cdn.com/v4/letter/j/ecd19e/32.png) [@jaredgibb](https://community.weweb.io/u/jaredgibb)\
**Post date:** [June 15, 2023, 11:08pm UTC](https://community.weweb.io/t/exclude-null-from-rollup/3068/3 "2023-06-15T23:08:45Z")

</div>

Add .filter(x =\> x != null)