crystal reports multiply decimal value on whole number does not produce correct result

Options

Hello,

Hopefully someone could help or point me in the right direction. Using fields from table and a formula to calculate %Complete along with Revenue Earned. The field table data is showing correctly, however, when attempting to find %Complete the value shows 0. I am able to format the number field to 0.0001 rounding so it shows correctly, but using that number to calculate revenue earned is not correct. So here are the numbers, hopefully someone can share what i am missing:

(1) % Complete (Actual Hours divided by Estimated Hours) 4/958.52 (should result to 0.0041731) With formatting can get it show

(2) Revenue Earned (Job Amount * % Complete) does not compute correctly, showing 429.0907 and should be 1049.13 (job Amount is 251,403) So $251,403 * 0.0041731 = $1049.13

Any suggestions to make this calculation work in CR as the calculator computes perfectly. Using CR 2016

Tagged:

Comments

Categories