Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

2 Decimal Points

Hi,

I have used 2 textboxes .

1.With text as density

2.with value

TextBox.png

In 2nd textbox,i want to display only 18.56. If i use round,it'll round to 18.

I want two decimal digits to display. Can somebody help me?

Regards,

Shruthi

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Use this function

  NUM(Value,'#,##0.00')

Thanks and Regards,

Vivek

View solution in original post

3 Replies
Not applicable
Author

Hi,

Use this function

  NUM(Value,'#,##0.00')

Thanks and Regards,

Vivek

er_mohit
Master II
Master II

Try to use num function with your expression

suppose i have sum(Value)= 18.5678

try this in text object

=num(sum(Value),'#.##0,00')

Anonymous
Not applicable
Author

Hi,

Try this one.

=NUM(sum(Value),'#.00')