Skip to Content
0
Former Member
Jan 08, 2011 at 12:34 PM

UDF to set the decimal places to the maximum amount of decimal places.

193 Views

Hi,

I have 3 source fields min, max,type and decimal place as target field

sample values will be like

min = 14.1 (decimal places = 1)

max = 14.123 (decimal places = 3)

type = 14.11 (decimal places = 2)

I want the maximum decimal count, in this case its 3 (14.123). So I need a UDF to count the no.decimals places and pass the highest decimal count value to target field

Thanks,

Varun