Don Your formula rounds down if the decimal part is less than 0.5; to round up to a whole dollar, this should work (I assume the dollar amount is non-negative, although the field format (G-$ZZ9.99) suggests the possibility of negative values):
if round[ PxFx ; 1 ] < PxFx then round[ PxFx; 1 ] + 1 else PxFx endif Robert -- Robert Pollard gplus.to/RobertPollard twitter.com/climatechange3 [email protected] 1.212.864.3156 2011/9/14 Don Friedman <[email protected]> > Brian - the formula *round[PxFx;1]* will do exactly that. > > > > > 2011/9/14 Brian Finn <[email protected]> > >> I need assistance creating a formula that will roundup a (G-$ZZ9.99) >> Field a whole dollar, any suggestions? >> >> Thank You >> -- >> >> Brian Finn >> Client Services / Database Administrator >> Local: 602-712-1515 Fax: 602-246-1782 >> Toll Free: 1-866-332-8453 >> Arizona Contractor License Center >> [image: Arizona Contractor License Center website]<http://www.azclc.com> >> [image: Follow AZCLC on >> Facebook]<http://www.facebook.com/pages/Arizona-Contractor-License-Center/107148999306616>[image: >> Follow AZCLC on Twitter] <http://twitter.com/ArizonaCLC>[image: Keep up >> to date with AZCLC] <http://www.arizona-clc.com/>[image: AZCLC >> Blog]<http://www.azclc.com/blog.xml> >> >> >> >> >> >> _______________________________________________ >> Dataperf mailing list >> [email protected] >> http://lists.dataperfect.nl/mailman/listinfo/dataperf >> >> > > > -- > *Don Friedman > ProfessionalRecords.Com LLC > PRS Data Systems > 205 S Main Street > Pittsburgh, PA 15215 > 412-784-1600 - 1-800-PRS-FILE > 412-784-1615 Fax* > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > >
<<rss_icon.png>>
<<23_5eef08f759bb5d47e094b9fb828ef8ed.jpg>>
<<twitter.png>>
<<reach_cast.png>>
<<facebook.png>>
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
