Goodmorning all, I have the following situation: I have a formula that multiplies 2 other formulas:
mailto:%7b@pending - {@pending days} * mailto:%7b@Per - {@Per Diem}
The issue is that the value that is produced from that mulitplication is off - typically by 1 -2 dollars. I have checked the rounding and other formatting.
The strange part is, that for testing purposes, I change the operator to + or - and the value produced is correct, yet when I choose * , it goes off.
Note: The value in field {@Per Diem} comes from a formula with dates, and I am thinking the issue can be here. Is there a way to convert this/affirm that the value from this field is acting as a standard number.
More info:
The formula which is giving an incorrect value is called: @PendingAmort(currency)
This formula multiplies the below 2 formulas: {@pending days} * {@Per Diem}
{@pending days} contains: {tb005_Amortization.MaturityDate} - {tb002_DateIni.Today_Run_D}
{@Per Diem} contains: {tb005_Amortization.OriginalAmount}*0.87/({tb005_Amortization.MaturityDate}-{tb005_Amortization.ValueDate})
Thank You, Marco sanchez Crystal 10 WinXP MS SQL
|