I am trying to make a formula and need some help. Here is what i have so far:
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!
We may be making this a little bit more complicated than it need to be. It seems unlikely the F18 will ever be less than 0 (it's the amount invested).
Just drop the isnumeric and make it > 0.