Skip to Content
Former Member
Sep 12, 2008 at 02:16 PM

Formula Help



I am trying to make a formula and need some help. Here is what i have so far:

{TranLink.TotValue}/ToNumber ({ProdInterim.F26Val})

This is taking the total value of a client's investment and dividing it by the amount they invested to get a gain/loss percent.

I check the formula in crystal reports and it says it has no errors. However, when I try to run the report from our database it gives an error message saying that there is a format issue in a formula. I know it's not any of the other formulas giving me this error because when I delete this one it runs fine. The TotValue field is a currency field and the F26Val is a text field if that would be the problem but to my understanding the ToNumber function should convert the text to number so I can do this. I Would really appreciate some help on this.

Also, I am trying to do a SUM of the F26Val Field and was wondering how to go about that.

Thanks in advance!