### Title

What is the difference between Auto-enter Calculation and a Calculation field concerning List function

### Post

Hello,

I have this Calculation field: PatternCount ( Substitute(List(Packages::PackageName); "¶"; ";") ; ";" )+1. The field is in a Payment table calculating how much commission a receptionist gets from selling promotion packages (the commission is based on the number of packages sold), which is stored in Package table. This works perfect. However, I tried using a Number field with Auto-enter Calculation using exactly the same formula, but it doesn't work.

Could somebody tell me why?

Thanks!

An auto-enter calc will not update (re-calculate a value) if the value that changes is from a field in a related table such as Packages in this example. An unstored calculation field would seem your best option unless you need a stored/indexed field. In the latter case, you are better off using a script performed by a script trigger.

And you can simplify your calculation to be:

Count ( Packages::PackageName )