fetch only first 2 decimals without rounding the numbers

Question

Fetch/show the 2 digits after decimal point without rounding off numbers.

Answer 1

Hi Geetha,

You can convert the decimal number into a string and then fetch the left n characters.

you can write code as LEFT(STR([number]),n).

The created field is added as a dimension, later convert into number by changing the data type.

Hope it helps you.