# Flowfield COUNT question

**URL:** <https://www.dynamicsuser.net/t/flowfield-count-question/17424>\
**Category:** User Forum\
**Created:** [September 19, 2007, 1:43pm UTC](https://www.dynamicsuser.net/t/flowfield-count-question/17424 "2007-09-19T13:43:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MortVader](https://avatars.discourse-cdn.com/v4/letter/m/a9adbd/32.png) [@MortVader](https://www.dynamicsuser.net/u/MortVader)\
**Post date:** [September 19, 2007, 1:43pm UTC](https://www.dynamicsuser.net/t/flowfield-count-question/17424/1 "2007-09-19T13:43:01Z")

</div>

Hi, I have a question regarding a flowfield count value from a table I have made:

CalcFormula currently looks like this, and works:  
Count(Serienr WHERE (Item=FIELD(No.),Sales Header=CONST()))

But I need one more filter, which would look like this:  
Count(Serienr WHERE (Item=FIELD(No.),Sales Header=CONST()),Serienr\<\>CONST())

But the **\<\>CONST()** is not allowed. Apparantly it is only possible to use the **=**. Not **\<\>**.

How is it possible to filter away all records where the text field value is empty?

Thanks in advance.

/Morten

---

<div class="post-metadata">

**Author:** ![DenSter](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/denster/32/7478_2.png) [@DenSter](https://www.dynamicsuser.net/u/DenSter)\
**Post date:** [September 19, 2007, 1:51pm UTC](https://www.dynamicsuser.net/t/flowfield-count-question/17424/2 "2007-09-19T13:51:23Z")

</div>

Instead of typing directly into that property, try clicking the ellipsis button (’…’). You will see the various options for setting up a calcformula. You are probably looking for FITLER instead of CONST.

---

<div class="post-metadata">

**Author:** ![MortVader](https://avatars.discourse-cdn.com/v4/letter/m/a9adbd/32.png) [@MortVader](https://www.dynamicsuser.net/u/MortVader)\
**Post date:** [September 19, 2007, 1:57pm UTC](https://www.dynamicsuser.net/t/flowfield-count-question/17424/3 "2007-09-19T13:57:42Z")

</div>

Wohoo… This just works! Thanks alot! 😃

---

<div class="post-metadata">

**Author:** ![DenSter](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/denster/32/7478_2.png) [@DenSter](https://www.dynamicsuser.net/u/DenSter)\
**Post date:** [September 19, 2007, 7:15pm UTC](https://www.dynamicsuser.net/t/flowfield-count-question/17424/4 "2007-09-19T19:15:34Z")

</div>

You’re welcome always happy to help :). Glad you could make it work.