Limiting an output to a integer

[#1]

Hi,

In an expression I am using ' / ' (divide) operator.

I want to limit the output to a integer.

How can I do it

Regards,

Rohit

[#2 · Accepted solution]

Hi,

If you are dividing a number by number it obviously return number.

i`m not able to understand the problem .

Can you pl ellaborate a bit and post your expression as well here.

-Peretson

[#3]

Thanks Kevin for showing interest.

Actually I want to exclude the digits after the decimal.

Is that possible

[#4]

hi,

use div() function

ex:div(n1,n2)

thanks

[#5]

Hi,

You can use num() function to format you expressionn output.

like num(sum(Sales),'#,##')

if you are using charts you can go to number tab and format you o/p.

- Peterson

[#6]

Thanks a lot for your replies..

div(n1,n2) worked..it was great

[#7]

Hi,

If you are dividing a number by number like this:

=5/3

Ans: 1.6666666666667

If you need to make limit like this:

=num( 5/3, '0.00' )

Ans: 1.67

Is it your answer?

i think i m not able to understand the problem .

Zaman