Skip to Main Content

Intelligent Advisor

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Remainder formulae not returning exact value as expected in case the dividend and divisor is less than 1

User_3YQHTAug 17 2023

We have observed one thing that that the remainder formulae is not returning the value as expected in case the dividend and divisor is less than 1.

In our case the dividend is 0.912 and divisor is 0.048 , the remainder formulae is showing us the asset value as 0 but the value contained is 1.38777878E-17 (scientific notation) for 0.0000000000000000138777878. This is resulting in our boolean not getting evaluated ,which has been defined in case “the asset value is 0”.

Can anyone suggest the working of Remainder formulae in case of non whole number.

Any leads is appreciated.

This post has been answered by Richard Napier on Aug 17 2023
Jump to Answer
Comments
Post Details
Added on Aug 17 2023
2 comments
415 views