Multiplication Mess

[obtechuser]

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.

AHHH!

Thank You,
Marco sanchez
Crystal 10
WinXP
MS SQL

 

[obtechuser]

Update:

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.

 

[kskid]

Please post both formulas

 

[obtechuser]

The formula which is giving an incorrect value is called: @PendingAmort(currency)

This formula multiplies 2 other formulas and contains:
{@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})