How to get Whole and decimal part of a number?

[#1]

Hello,

I have number say - 2.35

I need function to get 2 and another function to get 35

Regards,

Naeem

[Miguel_Angel_Baeyens]

Hi Mohammed,

Use the Frac() function.

Miguel

[Anonymous]

... and the Floor() function for the whole bit.

[Anonymous]

Hi,

Check http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors

[anbu1984]

=SubField(2.35,'.',1) //Returns 2

=SubField(2.35,'.',2) //Returns 35