Currency Calculation

[Chris Christou]

I am currently trying to create a currency calculation field that uses data from another number field as the Format>Number menu in layouts is not an option.

My question is:

If a field named Num contains: 100

How can i create a calculation that will display 100.00

I have tried various number functions including:

Truncate ( Num ; 2 )

Round ( Num ; 2)

but can not find any calculation functions that can do this.

[comment]

See here:

http://www.fmforums.com/forum/showpost.php?post/257391/

[Chris Christou]

Thanks.

That worked a treat!