Rounding sort of ....

[Kenneth Brody]

On 8/23/2018 6:36 PM, Bruce Easton via Filepro-list wrote:
> Yes. (I'm assuming when you say 'and leave whole numbers' that you mean 
> whole dollars since you also mentioned cents.)
> 
> You should be able to do it on one line using a dummy field as an 
> intermediate result - let's say your field in question is field #4:
> 
> Then:  4=4-".01"; aa(10,.0)=4; 4=aa
[...]

Remember that the function DOEDIT() can be used to eliminate the temp dummy 
field:

     4 = doedit(4-"0.01",".0")

-- 
Kenneth Brody


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus