# Using fractions in value list generated calculations

This topic is 2912 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

For my cabinetshop we often need to calculate the thickness of tile backslashes.

We build everything in metric but we communicate with our customers in imperial dimensions.

The various options for tile thickness are selected from a drop down value list.

For these values to be viable in a calculation they must be entered as a decimal.

If the inputed value starts out as a fraction the end result is gibberish.

The problem we have is our customers cannot sometimes relate to decimal equivalencies.

They don't readily understand that .375 is the same as 3/8 inch.

The attached file shows the results if we start with fractions or if we start with decimals.

Is there a way to use fractions as the value list input without filemaker considering them to be text values?

fractions.fmp12.zip

##### Share on other sites

FileMaker will treat "3/8" as a text string as by using it in a calculation you are forcing FM to implicitly treat it as a number.  Which results in the number 38.  You can test this for yourself by checking this in the data viewer:

getasnumber( fractions::backsplash thickness from valuelist A )

You can however force FM to evaluate that text string as fraction by doing this:

Evaluate ( fractions::backsplash thickness from valuelist A)

which will result in 0.375

like you expect it to be

##### Share on other sites

Change the definition of Metric Equivalence A to:  25.4 * Evaluate(backsplash thickness from valuelist A)

oops. Wim beat me to it.

Edited by Matthew F
##### Share on other sites

Thanks guys!  That was just what I needed.

##### Share on other sites

This topic is 2912 days old. Please don't post here. Open a new topic instead.

## Create an account or sign in to comment

You need to be a member in order to leave a comment

## Create an account

Sign up for a new account in our community. It's easy!

Register a new account