Goodmorning all, I have the following situation:
I have a formula that multiplies 2 other formulas:
{@pending days} * {@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
Edited by obtechuser - 01 Apr 2008 at 8:54am