rounding

[Josh Reader]

Hi Robart,

You could use INSTR or RINSTR to find the end of the number (or where the decimal is located if there is a decimal point).  Then use programing to say if that last number of the string is greater or equal to 2.5 and less than 5, make it 5.  If it's less than 2.5 make it 0.  If it's greater or equal to 7.5 make it 10.  If it's less 7.5 and greater than 5, make it 5.

Josh

-----Original Message-----
From: Filepro-list <filepro-list-bounces+josh.reader=mercuryelectronics.com at mailman.celestial.com> On Behalf Of Whiting, Robart A. via Filepro-list
Sent: Monday, June 17, 2024 10:23 AM
To: Filepro-list at mailman.celestial.com
Subject: RE: rounding

IS there a way to round to the nearest 5 in Filepro 6.0 on Windows?
I apologize for any etiquette errors in posting.

Robart Whiting
Financial Aid Officer
Miami Lakes Educational Center
and Technical College
5780 NW 158 St
Miami Lakes, FL 33014
305/557-1100 x2256
But We Decide Which Is Right
And Which Is An Illusion - Graham Edge

-----Original Message-----
From: Filepro-list <filepro-list-bounces+whitingr=dadeschools.net at mailman.celestial.com> On Behalf Of Whiting, Robart A. via Filepro-list
Sent: Friday, May 10, 2024 9:12 AM
To: Filepro-list at mailman.celestial.com
Subject: reoccurring error when running report

CAUTION: This email originated outside of dadeschools.net. Do not click on links or attachments unless you are expecting the email or recognize the sender and know the message is safe.


This is the first time I've posted to the listserve, please excuse any protocol errors.

I have been running Filepro for many years (decades).

All my formats and reports are rolled over from year to year.  Just recently I've been receiving the following error message.  It's never happened in previous years.

 [cid:e7ed8c71-d8dc-4693-afa5-22ab138c46c7]

Thank you.


Robart Whiting

Financial Aid Officer

Miami Lakes Educational Center

and Technical College

5780 NW 158 St

Miami Lakes, FL 33014

305/557-1100 x2256

But We Decide Which Is Right

And Which Is An Illusion - Graham Edge
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20240510/a4f125f3/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/jpeg
Size: 47788 bytes
Desc: image.png
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20240510/a4f125f3/attachment.jpe>
_______________________________________________
Filepro-list mailing list
Filepro-list at mailman.celestial.com
Subscribe/Unsubscribe/Subscription Changes https://mailman.celestial.com/mailman/listinfo/filepro-list
_______________________________________________
Filepro-list mailing list
Filepro-list at mailman.celestial.com
Subscribe/Unsubscribe/Subscription Changes https://mailman.celestial.com/mailman/listinfo/filepro-list