Fraction Field Values

[ba11]

Hi All,

I have a Table field with fraction values. i.e 1/16, 4/12, 1/240 etc. I have another Table field that I'd like to divide these fraction values with but I only need the denominators. I tried this in my app but it returned null values.

Is there a function I can use in the load script that returns just the values after '/' so it's easier to use in the app? Basically to separate the nominator and denominator into two different values.

Thanks in anticipation.

[ba11]

Hi All,

I have a Table field with fraction values. i.e 1/16, 4/12, 1/240 etc. I have another Table field that I'd like to divide these fraction values with but I only need the denominators. I tried this in my app but it returned null values.

Is there a function I can use in the load script that returns just the values after '/' so it's easier to use in the app? Basically to separate the nominator and denominator into two different values.

Thanks in anticipation.

[steeefan · Accepted solution]

Yes, there is. It's called SubField().

[ba11]

Thank you.