Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
num((sum(if(BG_STATUS='Rejected',1,0))/count(BG_BUG_ID))*100 ,'##.##')
Try this
num(((sum(if(BG_STATUS='Rejected',1,0))/count(BG_BUG_ID))*100),'#,##')
=round ( (sum(if(BG_STATUS='Rejected',1,0))/count(BG_BUG_ID))*100 , 0.01 )