How to make filemaker read fractions
I am using fractions from a field to do calculations and it is not working properly. It works when I use a number like 1 but something happens when I use1/2
How are you setting this up?
If you enter the text 1/2 into a text field, Evaluate ( TheTextField ) should return a value of 0.5
just as though you entered 1/2 into the specify calculation dialog where FileMaker will interpret it as 1 divided by 2.
I don't know why it was reading it like that. I created an evaluate field like you said above and base the calculations of that decimal field instead and it all works now.
Retrieving data ...