=Num() query

[knightwriter]

Hi All,

I am trying to divide two expressions by one another and the end result to give me xx.0. I have used the below and the answer I get is xx.xxxxxxxxxxxxx. What am I doing wrong?

=num(expression1), '##.0') / num(expression2). '##.0')

[prajapatiamar38]

Hi

try this:

=num((expression1), '##.0') / num((expression2), '##.0')

[knightwriter]

thanks for the reply but this does not solve my query.

[mohammadkhatimi]

Hie..

Goto chart properties-->>Numbers Tab-->>Select Integer-->>in that '##.0'

Hope this will helps you..!!

Regards,

Mohammad

[knightwriter]

Hi

Unfortunately I am using text box properties and your suggestion is not available.

[mohammadkhatimi]

Try this

=num(num((expression1), '##.0') / num((expression2), '##.0'),'##.0'))

or

=num(expression1 /expression2, '##.0')

Hope this will helps you..!!

Regards,

Mohammad

[MarcoWedel · Accepted solution]

=num(expression1 /expression2, '##.0')

[prajapatiamar38]

can you post your expression?

[sasiparupudi1]

=num(expression1/expression2), '##.0')