Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Formula Help

Hello,

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!

Former Member
Former Member replied

Robert,

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.

Jason

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question