Skip to main content
Question

numeric formatting limit digits

  • March 5, 2014
  • 0 replies
  • 72 views

I have two numeric formulas that use price & percentage. However the results are quite long and I want to limit what it displays or round up.

for example the results are like this: 24.369918699187% & $1.5504166666667

I would like it to display and export like this: 24% & $1.55.

Can anyone give some advice on how I might go about doing this?



This topic has been closed for replies.

If you were just concerned about how it displays, then you could set the field properties as to how many decimals to display. But you also said "export to excel" - so you will need to change your actual formula to round.



For the formula which has the percentage, try this

Round(

..then keep your formula here

,0.0001)



For the formula which has the $ amount, try this

Round(

..then keep your formula here

,0.01)









  • CeceliaMartin
  • Author
  • Quickbase Alumni
  • March 5, 2014
that is great.  what if I didn't want to round but just wanted to show/export those decimal places...which would I use?
  • CeceliaMartin
  • Author
  • Quickbase Alumni
  • March 6, 2014
that is great.  what if I didn't want to round but just wanted to show/export those decimal places...which would I use?
If you want to change how it displays in Quickbase, but still want to preserve all the decimals for exports! then don't do that around formula at all.  Just change the Field properties to set the number of digits for rounding for presentation purposes on forms and reports.
  • CeceliaMartin
  • Author
  • Quickbase Alumni
  • March 6, 2014
I actually want to export without the decimals also.  Is there something like round that can be used?
I'm confused by this last comment.  I gave the formula in my original answer of how to set the rounding for export.  I must not be understanding your latest comment.
  • CeceliaMartin
  • Author
  • Quickbase Alumni
  • March 6, 2014
sorry for the confusion.  So, yes the rounding works.  However my question is this:  I have a number: $2.5567.  I do NOT want to round but I want to display and export it as $2.55 (so it is not automatically rounding up to $2.56 but just displaying & exporting the first two decimal places). I also have a percentage 30.5555%, I want to display & export to excel as 30% (again not rounding up to 31%), Is that possible to show the number like that without rounding?
Terms & ConditionsAccessibility statement