Separate a calc. value with decimals

[snekkis]

I have a OCR invoice which needs to separate the decimal slightly to the right. Now, I use two equal fields of the value and paste and patch to cover the whole numbers and separator so only the decimals show in the right field.

This doesn't feel very professional, but I'm willing to learn???

Snekkis

[ernst]

Hi Snekkis,

If you want to split your value-field into a whole number and decimals you can use the following calulations:

whole number = Case(Round(Value, 2) < 0 , "-") & Truncate(Round(Abs(Value), 2), 0 )

decimals = Right(100 + Mod(Round(Abs(Value) * 100 , 0 ), 100 ), 2 )

These calcs give you text as output, the decimals have two 'places'.

Hope this helps,

Regards,

Ernst.

[snekkis]

Just what I wanted.

Thanks, Ernst!