FirstSpirit can calculate

[Peter_Jodeleit]

Ok, perhaps nothing for every-day-templating...

The first 10 square numbers:
   $CMS_VALUE([1..10].map(x -> x*x))$
Even numbers between 1 and 100:
   $CMS_VALUE([1..100].filter(x -> x.even))$
   $CMS_VALUE([1..50].map(x -> x * 2))$
The count of numbers between 1 and 100:
   $CMS_VALUE([1..100].fold(start:0,  x -> start+1))$
The sum of numbers from1 and 100:
    $CMS_VALUE([1..100].fold(y:0, x -> x+y))$==$CMS_VALUE((100 * 101) /  2)$
The product of numbers from 1 to 100 (factorial):
    $CMS_VALUE([1..100].fold(y:1, x -> x*y))$

Try the last one in a calculator

Tested with FS4.2R2

[boesebeck]

i add the tag knowledgebase, you can pretty combine this with Sort / Filter database records  afterwards  by a field in a foreign table

[boesebeck]

i moved this post to the developer blog

[gorecki]

This is very nice!