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:

financial calculation (2000) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) required fields (1999) [OT] Mac OSX hardware test software (2004) New public beta available (1997) Yet another db manager (2004) Limiting user access to .tmpl files (1997) Two submit buttons ? (1997) WebDNA Book? (2003) $Replace with [founditems] (1997) syntax question, not in online refernce (1997) WebMerchant 1.6 and SHTML (1997) No Line Breaks from OSX server (2002) Tip: upgrading to WebCatalog 3.x, fields to watch for (1999) Getting total number of items ordered (1997) Regarding PayPal (was Payments -> Bank Accounts) (2005) RE: type 2 errors with ssl server (1997) [OT] Theiving B*****ds (2004) Jimmy Houssen (1998) Formulas.db + Users.db (1997)