to always round up (ie: $111.01 rounds to $112). I believe the formula from
my earlier E-mail does that (assumes value is in RV1):
convert["G-$ZZ9";subfield[apply.format["G-ZZ9.99";RV1+.99];".";1]]
Pat Riley
At 07:02 PM 9/14/2011, you wrote:
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
- _______________________________________________
- 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
Content-Type: image/png; name="facebook.png"
Content-ID: <[email protected]>
X-Attachment-Id: 567d70bebb715a09_0.0.1.2
Content-Type: image/png; name="twitter.png"
Content-ID: <[email protected]>
X-Attachment-Id: 567d70bebb715a09_0.0.1.3
Content-Type: image/png; name="rss_icon.png"
Content-ID: <[email protected]>
X-Attachment-Id: 567d70bebb715a09_0.0.1.5
Content-Type: image/png; name="reach_cast.png"
Content-ID: <[email protected]>
X-Attachment-Id: 567d70bebb715a09_0.0.1.4
Content-Type: image/jpeg; name="23_5eef08f759bb5d47e094b9fb828ef8ed.jpg"
Content-ID: <[email protected]>
X-Attachment-Id: 567d70bebb715a09_0.0.1.1
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
