Chris Christou Posted October 12, 2007 Share Posted October 12, 2007 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. Link to comment Share on other sites More sharing options...
comment Posted October 12, 2007 Share Posted October 12, 2007 See here: http://www.fmforums.com/forum/showpost.php?post/257391/ Link to comment Share on other sites More sharing options...
Chris Christou Posted October 12, 2007 Author Share Posted October 12, 2007 Thanks. That worked a treat! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6182 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now