How to compare feet/inches values in Crystal Reports?
Clash Royale CLAN TAG #URR8PPP 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 won't it return the same for 0' 0" and 0' 1"? – Peter just now ...