Brian, assuming your value is in RV1, the below should do what you want:

     convert["G-$ZZ9";subfield[apply.format["G-ZZ9.99";RV1+.99];".";1]]

Good luck,

Pat Riley



At 05:01 PM 9/14/2011, you wrote:
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
Arizona
                Contractor License Center website
Follow
                AZCLC on Facebook Follow
                AZCLC on Twitter Keep up
                to date with AZCLC AZCLC
                Blog






_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf

Reply via email to