Multi tool use

Clash Royale CLAN TAG

How to compare feet/inches values in Crystal Reports?

I have dimension string value stored in the following format: 0' 0"

I need a formula to check whether the value is greater than zero (0' 0"). Can anyone please advise what I need? I am just starting with Crystal Reports.

1 Answer
1

Use the Val() function.

Val()

Val (str)


Arguments
str is a text string.

str

Returns
Fractional Number

Action
The Val (str) function reads a string containing Numbers (example: an address, phone number, or social security number) and converts them to a decimal value. Val stops reading the string when it finds the first character in the string that it finds that it cannot recognize as a number or as a space.

Val (str)

Val

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.