Not applicable
2014-08-21
02:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 Decimal Points
Hi,
I have used 2 textboxes .
1.With text as density
2.with value
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
737 Views
1 Solution
Accepted Solutions
Not applicable
2014-08-21
02:02 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 Replies
Not applicable
2014-08-21
02:02 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Use this function
NUM(Value,'#,##0.00')
Thanks and Regards,
Vivek
er_mohit
Master II
2014-08-21
02:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
2014-08-21
02:19 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try this one.
=NUM(sum(Value),'#.00')
623 Views