Re: [WebDNA] Formatting numbers - truncation instead of rounding

This WebDNA talk-list message is from

2011

It keeps the original formatting. numero = 107470
interpreted = N
texte = --000e0ce0b1a64076f704af0598a6Content-Type: text/plain; charset=ISO-8859-1*Drop-off not Round-off*courtesy from Brian FriesTry this:178.9964 =[math][math]((floor(178.9964*100))/100)[/math]On Mon, Oct 10, 2011 at 5:20 AM, Diane Blackmore wrote:> Hi>> Can anyone tell me the best way to truncate a number using [format] rather> than having it round up/down.>> Eg. I have 178.9964 as a value, and I need 178.99 as the outcome>> Obviously using [format .2f][value][/format] will round this to 179.00, so> I need another method.>>> Thanks all,>>>>>>--000e0ce0b1a64076f704af0598a6Content-Type: text/html; charset=ISO-8859-1Content-Transfer-Encoding: quoted-printableDrop-off not Round-off
courtesy from =Brian Fries

Try this:

178.9964
=A0=3D
[math]
[math]
((fl=oor(178.9964*100))/100)
[/math]

On= Mon, Oct 10, 2011 at 5:20 AM, Diane Blackmore <diane@cohesion.co.nz> wrote=:


Hi

Can anyone tell me the best way to truncate a number using [format] rather =than having it round up/down.

Eg. I have 178.9964 as a value, and I need 178.99 as the outcome

Obviously using [format .2f][value][/format] will round this to 179.00, so =I need another method.


Thanks all,






--000e0ce0b1a64076f704af0598a6-- Associated Messages, from the most recent to the oldest:

Re: [WebDNA] Formatting numbers - truncation instead of rounding (sgbc cebu 2011) Re: [WebDNA] Formatting numbers - truncation instead of rounding (Donovan Brooke 2011) Re: [WebDNA] Formatting numbers - truncation instead of rounding (Govinda 2011) [WebDNA] Formatting numbers - truncation instead of rounding (Diane Blackmore 2011)

--000e0ce0b1a64076f704af0598a6Content-Type: text/plain; charset=ISO-8859-1*Drop-off not Round-off*courtesy from Brian FriesTry this:178.9964 =[math][math]((floor(178.9964*100))/100)[/math]On Mon, Oct 10, 2011 at 5:20 AM, Diane Blackmore wrote:> Hi>> Can anyone tell me the best way to truncate a number using [format] rather> than having it round up/down.>> Eg. I have 178.9964 as a value, and I need 178.99 as the outcome>> Obviously using [format .2f][value][/format] will round this to 179.00, so> I need another method.>>> Thanks all,>>>>>>--000e0ce0b1a64076f704af0598a6Content-Type: text/html; charset=ISO-8859-1Content-Transfer-Encoding: quoted-printableDrop-off not Round-off
courtesy from =Brian Fries

Try this:

178.9964
=A0=3D
[math]
[math]
((fl=oor(178.9964*100))/100)
[/math]

On= Mon, Oct 10, 2011 at 5:20 AM, Diane Blackmore <diane@cohesion.co.nz> wrote=:


Hi

Can anyone tell me the best way to truncate a number using [format] rather =than having it round up/down.

Eg. I have 178.9964 as a value, and I need 178.99 as the outcome

Obviously using [format .2f][value][/format] will round this to 179.00, so =I need another method.


Thanks all,






--000e0ce0b1a64076f704af0598a6-- sgbc cebu

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Version f1 status (1997) PCS Frames (1997) database visibility (2000) Searchable WebCat (etc.) Docs ? (1997) Random Number Generator works for Ranges of Numbers (1997) Location of Webcat site in folder hierarchy (1997) ThreadMem ignored? (1998) Web Catalog 2 demo (1997) Export database record - append to other database (2005) changing order number (1998) Duplicate Messages (1998) Converting Esiting Html Table Forms to WebCat (1997) Protect (1997) [WebDNA] WebDNA Crashing or Not **YES** (2008) [OT] - Credit card processing company fees (2004) ImageMagick on OSX (2003) Another bug to squash (WebCat2b13 Mac .acgi) (1997) WebDNA Solutions ... sorry! (1997) Bulk Email Limits (2001) still having shipCost.db Problem (1997)