round

Syndicate content

QuickBase users may notice small discrepancies when rounding and comparing floating point numbers. For example, Round(37.785,0.01) returns 37.78 instead of 37.79. This is not a QuickBase-specific issue; the discrepancies happen because some floating point numbers cannot be represented exactly in the binary format required by computers and are instead approximated. 

August 15th, 2011 - 12:08 PM

There is a way to do this using Application Variables and a Formula User field.

The first thing you need to do is define the number of users that will be participating in the 'round-robin' by creating an Application Variable. For this example let s call the variable [number_of_reps]

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit