Formula for an older version of CR

[mjstanton]

Hello,

I have an old report that was created using CR 5. It's embedded in a Lotus Notes Expense Reporting database. The report is generating an error message. It says:
Error in formula <Text to Number> 'ToNumber ({Consolidated_Expenses.$14})' The string in non-numeric.

I was able to open the report in CR 8.5. I changed the formula to (if isnull ({Consolidated_Expenses.$14}) or not (isnumeric({Consolidated_Expenses.$14}))or trim ({Consolidated_Expenses.$14}) = "" then 0 else tonumber ({Consolidated_Expenses.$14}))

Checking the formula finds no errors. But in order to save the change, the report gets saved as a CR 8.5 report. When I try to replace the old report with the new one, I get an error message. I've tried numerous times to replace it, with no success (there are many other files in the folder that were all created using version 5).

So I found a copy of CR 5 and I changed the formula to the one I used above. In checking the formula, I am told that a parenthesis (the close parenthesis) is missing. The cursor blinks inside the open parenthesis right before "isnumeric". The formula is exactly how it was in 8.5, which was fine. I'm beginning to think that "isnumeric" might not be function recognized in the earlier version of CR. Can anyone verify this for me, and if I'm right, is there a different function that serves the same purpose in CR 5?

Thanks a lot in advance!
MJ

 

[IanWaterman]

Not totally sure, but I think Isnumeric came out in 8.5. I think prior to that for version 7 the function was numerictext

May have been around in CR5 and works same way.

Ian

 

[mjstanton]

Thank you so much, Ian. It worked!!!!!

MJ