Re: [xmpie-users] Re: Currency

[Guillaume Besnier]

You wrote that "is it not rounding the number up". Could you say what it does instead? Please provide several examples.

As explained in the uDirect Manual page 217, the "Round" function does not round the provided number up, but to the nearest value, according to the number of decimals specified in the second parameter (e.g. the nearest integer value, should the second parameter be zero).

To always round the provided value up to an integer, consider using the "Ceil" function; see uDirect Manual page 215.

-------- Message original --------
Sujet: [xmpie-users] Re: Currency
De : VDP user <pam.per...@marekgroup.com>
Pour : xmpie...@googlegroups.com
Date : 15/08/2012 02:29

I did try that expression but it is not rounding the number up. Any other suggestions? I greatly appreciate your help :)

 

 

On Tuesday, August 14, 2012 7:11:31 PM UTC-5, Mark wrote:

Hi, 

 

The number 2 after the fields says to round it to 2 decimal places.

Please check the manual for FormatNumber which should achieve what you want (see my sample below, but make sure you test it first)

"$" & FormatNumber(round(|->[money], 2), "#############.00")

Regards,

On Wednesday, August 15, 2012 9:46:24 AM UTC+10, VDP user wrote:

That worked for the16.867825 number. How would I write it for something like this 58294.4?

 

What is the number two after the field name?

 

 
On Tuesday, August 14, 2012 6:07:03 PM UTC-5, Mark wrote:

Hi,

Refer to the "round" function in the manual. For example if your Number ADOR was called "money" you would do something like this:

"$" & Round(|->[money], 2)

Regards,

Mark.

On Wednesday, August 15, 2012 8:54:12 AM UTC+10, VDP user wrote:

How do I write a rule to change a number to currency: (sample: 16.867825) that I need to be $16.87?

--
You received this message because you are subscribed to the Google Groups "XMPie Interest Group" group.
To view this discussion on the web visit https://groups.google.com/d/msg/xmpie-users/-/j0tiCl8A0T8J.
To post to this group, send email to xmpie...@googlegroups.com.
To unsubscribe from this group, send email to xmpie-users...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/xmpie-users?hl=en.