Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2008 Server
>>I'm embarrassed to ask this:
>>
>>I can't figure out how to display a numeric value with the trailing zeroes trimmed. So, if the value is stored in the table as 88.99000, I want the value to display in a report as 88.99.
>
>Do you want to always trim off any trailing zeroes, or do you want to always display a fixed number of decimal places?
>
>The former is unusual in my experience. In cases where things such as parts prices are recorded to fractions of a cent, users often want to see those fractions even if they are zero, to confirm that's the value and not some rounded amount.
>
>If you have values like 88.991 or 88.9901, then trimming trailing zeroes will lead to a ragged right edge in columns of numbers on a report and/or inconsistent position of the decimal point, both of which can make a report harder to read.
In my case this doesn't matter, since it is just one value per label, not a bunch of detail lines.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement