Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display Value in Text Object with 2 digit after decimal point

Hi All,

I've Gauge chart and using Digital number value like 22.45.Now i want to display the same value in text box instead of 
digital number.

I tried with text object but it showing value like 22.43273761.I want display only 2 digit after decimal point.

My expression is :

=(sum(if(BG_STATUS='Rejected',1,0))/count(BG_BUG_ID))*100

3 Replies
Anonymous
Not applicable
Author


num((sum(if(BG_STATUS='Rejected',1,0))/count(BG_BUG_ID))*100 ,'##.##')

sagarkharpude
Creator III
Creator III

Try this


num(((sum(if(BG_STATUS='Rejected',1,0))/count(BG_BUG_ID))*100),'#,##')

Anonymous
Not applicable
Author

=round ( (sum(if(BG_STATUS='Rejected',1,0))/count(BG_BUG_ID))*100 , 0.01 )