formula problem

[evilmousse]

argh, this makes no sense, the following code won't run:

if Sum ({procSoldLoansConfByInvRpt;1.Loan Amt})>0
then
sum({procSoldLoansConfByInvRpt;1.Spread}) / Sum ({procSoldLoansConfByInvRpt;1.Loan Amt})
else
0

i get an error Sum ({procSoldLoansConfByInvRpt;1.Loan Amt}) is not a number

so sum(a) / sum(b) won't compile.

but i HAVE compiled
sum(b) / sum(a)
and
sum (a) + sum(b)

so what the heck?!?!?

 

[dgillz]

Where are you placing this formula?

Also, what is the data type of {procSoldLoansConfByInvRpt;1.Loan Amt} ?

FInally, what do you mean by "Won't compile" ? This is new terminolgy to me in regards to Crystal reports.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[evilmousse]

spread is a calculated value in the query (decimal to 3
places), loan amt is money.

when i said won't compile, i referred to the fact that i
can't save the formula field without it prompting when i try to save, "there is a syntax error with the formula",
then point me to the donominator citing 'value must be
numeric'.

what really irks me is that the problem is not
reflexive.. ie the sum(b)/sum(a) i mentioned above works,
but my sum(a)/sum(b) doesn't.

-g

 

[evilmousse]

wrapped the loanamt denominator in a cdbl() function and it worked.

what the heck ever. thppppt.

-g