Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Multiplication Mess Post Reply Post New Topic
Author Message
obtechuser
Newbie
Newbie
Avatar

Joined: 01 Apr 2008
Location: United States
Online Status: Offline
Posts: 1
Quote obtechuser Replybullet Topic: Multiplication Mess
    Posted: 01 Apr 2008 at 6:14am

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
IP IP Logged
jon2ryhme
Newbie
Newbie


Joined: 03 Apr 2008
Location: United Kingdom
Online Status: Offline
Posts: 16
Quote jon2ryhme Replybullet Posted: 07 Apr 2008 at 8:25am

Hi I think this will solve your problem.

ToNumber ({@pending days}) * ToNumber ({@Per Diem})
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.