Enter Fraction Values on NAV

pferreira

Hello,

I would like to know if it is possible to save values as a fraction. IE: US and UK size charts where you have 28 3/4, etc
I don't know if there is any special property, like a SQL collation, or something that suports saving the data in this format.

Slawek_Guzek

SQL server does not offer any collation allowing storing values as fractions. The only option is to save them as text, which of course will prevent any arithmetic operations on them.

Slawek_Guzek

SQL server does not offer any collation allowing storing values as fractions. The only option is to save them as text, which of course will prevent any arithmetic operations on them.

kriki

You could also define them as option. If you do it well, you can use the option value to do calculations.
e.g.:
value = caption
1 = 1/8
2 = 1/4
3 = 3/8
4 = 1/2
5 = 5/8
6 = 3/4
7 = 7/8

pferreira

Hi guys, thank you for all the replies.
I'll go with basic solution, since this is only to use on a couple of layouts, where we setup the decimal value and the text conversion on a table (IE: 125 is 1/8, 25 is 1/4).
I thought there would be some kind of solution, since this is common on sizing on the US and UK, but no luck.