# Field CalcFormula Verification

**URL:** <https://www.dynamicsuser.net/t/field-calcformula-verification/52192>\
**Category:** Technical Forum\
**Created:** [April 17, 2014, 4:28pm UTC](https://www.dynamicsuser.net/t/field-calcformula-verification/52192 "2014-04-17T16:28:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mravellan](https://avatars.discourse-cdn.com/v4/letter/m/d26b3c/32.png) [@mravellan](https://www.dynamicsuser.net/u/mravellan)\
**Post date:** [April 17, 2014, 4:28pm UTC](https://www.dynamicsuser.net/t/field-calcformula-verification/52192/1 "2014-04-17T16:28:58Z")

</div>

Hello NAV group,

I am new to this community and fairly new to NAV. I have small question and a favor to ask. Can anyone verify that I am entering the AND filter code correctly below.

To briefly describe, I located a formula that is calculating a Quantity column from a separate table. The formula is working fine but I want to add an additional filter to it where it sums up a certain location as well. Below is the original formula that works and calculates everything. Right below that, I added what I thought was the correct “AND” formula to include the location. Please let me know if its correct as I am not able to compile. Thank you all.

**Original Formula:**  
Sum(“Item Ledger Entry”.Quantity WHERE (Item No.=FIELD(No.),  
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Drop Shipment=FIELD(Drop Shipment Filter),Variant Code=FIELD(Variant Filter),Lot No.=FIELD(Lot No. Filter),Serial No.=FIELD(Serial No. Filter)))

**Proposed Solution:**

Sum(“Item Ledger Entry”.Quantity WHERE (Item No.=FIELD(No.)**& (Location Code=”North")**,Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Drop Shipment=FIELD(Drop Shipment Filter),Variant Code=FIELD(Variant Filter),Lot No.=FIELD(Lot No. Filter),Serial No.=FIELD(Serial No. Filter)))

---

<div class="post-metadata">

**Author:** ![mravellan](https://avatars.discourse-cdn.com/v4/letter/m/d26b3c/32.png) [@mravellan](https://www.dynamicsuser.net/u/mravellan)\
**Post date:** [April 17, 2014, 10:29pm UTC](https://www.dynamicsuser.net/t/field-calcformula-verification/52192/2 "2014-04-17T22:29:31Z")

</div>

Ok I figured it out:

**Location Code=FILTER(North)**