# Storing and reading a formula

**URL:** <https://www.dynamicsuser.net/t/storing-and-reading-a-formula/9571>\
**Category:** Developers Forum\
**Created:** [January 13, 2005, 5:17pm UTC](https://www.dynamicsuser.net/t/storing-and-reading-a-formula/9571 "2005-01-13T17:17:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dashenk23](https://avatars.discourse-cdn.com/v4/letter/d/85f322/32.png) [@dashenk23](https://www.dynamicsuser.net/u/dashenk23)\
**Post date:** [January 13, 2005, 5:17pm UTC](https://www.dynamicsuser.net/t/storing-and-reading-a-formula/9571/1 "2005-01-13T17:17:03Z")

</div>

Hello, I am trying to store a formula on a Shipping Agent record that will be used to calculate a check digit for a Pro Number…example Var1 MOD Var2. The problem I am having is that when I try to read this in my code, Navision does not understand this is a formula, it treats it as text…can anyone think of a way to do this…? We want the customer to be able to define the formula to use for calculating the Number.

---

<div class="post-metadata">

**Author:** ![Nelson](https://avatars.discourse-cdn.com/v4/letter/n/dec6dc/32.png) [@Nelson](https://www.dynamicsuser.net/u/Nelson)\
**Post date:** [January 13, 2005, 9:01pm UTC](https://www.dynamicsuser.net/t/storing-and-reading-a-formula/9571/2 "2005-01-13T21:01:38Z")

</div>

Hi, take a look at these topics: [http://www.mbsonline.org/forum/topic.asp?TOPIC\_ID=12748&SearchTerms=code,field,formula,AL](http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=12748&SearchTerms=code,field,formula,AL) [http://www.mbsonline.org/forum/topic.asp?TOPIC\_ID=10179](http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=10179) I found them by searching the forum for **code field formula AL** (AL as in C/AL [:)]).