# problem runnig table

**URL:** <https://www.dynamicsuser.net/t/problem-runnig-table/51044>\
**Category:** Technical Forum\
**Created:** [February 20, 2014, 9:43am UTC](https://www.dynamicsuser.net/t/problem-runnig-table/51044 "2014-02-20T09:43:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aymennn](https://avatars.discourse-cdn.com/v4/letter/a/977dab/32.png) [@Aymennn](https://www.dynamicsuser.net/u/Aymennn)\
**Post date:** [February 20, 2014, 9:43am UTC](https://www.dynamicsuser.net/t/problem-runnig-table/51044/1 "2014-02-20T09:43:03Z")

</div>

hello,

i have this error when i ran the table N° 13(salesperson/purchaser):

the flowfield value can not be calculated.

you must define and activate a key that contains the following key fields in any order and then associate the specified sumIndexField with it.

Key Fields: Type

SumIndexField: Amount

Table: Sales Transaction

can you help me please?

thank you.

---

<div class="post-metadata">

**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\
**Post date:** [February 20, 2014, 9:53am UTC](https://www.dynamicsuser.net/t/problem-runnig-table/51044/2 "2014-02-20T09:53:01Z")

</div>

you need to add above mentioned key in table Sales Transaction

---

<div class="post-metadata">

**Author:** ![amol\_salvi](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@amol\_salvi](https://www.dynamicsuser.net/u/amol_salvi)\
**Post date:** [February 20, 2014, 9:58am UTC](https://www.dynamicsuser.net/t/problem-runnig-table/51044/3 "2014-02-20T09:58:01Z")

</div>

Is there any flowfield in Table which is referring value from another table ??

If yes then you have define the key in that table.

---

<div class="post-metadata">

**Author:** ![Aymennn](https://avatars.discourse-cdn.com/v4/letter/a/977dab/32.png) [@Aymennn](https://www.dynamicsuser.net/u/Aymennn)\
**Post date:** [February 20, 2014, 1:35pm UTC](https://www.dynamicsuser.net/t/problem-runnig-table/51044/4 "2014-02-20T13:35:55Z")

</div>

i defined this key in that table but another error appears:

the two fields bellow must have the same type.

Field: type filter ← Amount

Table: Vendeur/Acheteur ← Sales Transaction

Type: Option ← Decimal

---

<div class="post-metadata">

**Author:** ![amol\_salvi](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@amol\_salvi](https://www.dynamicsuser.net/u/amol_salvi)\
**Post date:** [February 20, 2014, 3:19pm UTC](https://www.dynamicsuser.net/t/problem-runnig-table/51044/5 "2014-02-20T15:19:59Z")

</div>

You should have both data type should be same .

YOu can not insert option data in decimal field.