Formula Help
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22542
Printed Date: 28 Apr 2024 at 3:02pm
Topic: Formula Help
Posted By: yeller
Subject: Formula Help
Date Posted: 07 Feb 2018 at 8:43am
I wrote 2 formulas and am attempting to combine them (multiply). The first formula is numeric. The second formula is text based. Although the second formula is a texted based user value field, the output is always numeric. Is there a way to combine them to produce a numeric total?
|
Replies:
Posted By: kevlray
Date Posted: 07 Feb 2018 at 12:43pm
Have attempted to convert the result of the second formula to a numeric? CDbl function?
|
Posted By: yeller
Date Posted: 08 Feb 2018 at 1:59am
Thank you, yes I have. Formula workshop gives the message: No errors found. As soon as I close the workshop it gives the error message: The string is non-numeric.
|
Posted By: kevlray
Date Posted: 08 Feb 2018 at 4:23am
Apparently not all your data can be converted to numeric. One way as a test is to use a formula like this to see when it does not like the data.
if isnumeric({somefield}) then 'true' else 'false'
|
|