Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
can any suggest me how to format numbers
for ex:- i have 45.5643678541315
I just want to round up to 3 decimal after .
like 45.564
I tried this expression =Sum((vAnnualusage), '##.##0')
 vardhancse
		
			vardhancse
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		in properties->Number<Tab>->we can give the desired number format as well
 
					
				
		
num(45.5643678541315,'#.000')
 
					
				
		
Pls close the thread
 
					
				
		
Hi,
properties->Number

 
					
				
		
it's in Text Object sasi. Thanks tho
 
					
				
		
ceil( 45.5643678541315,0.564)
or
floor(45.5643678541315,0.564)
 its_anandrjs
		
			its_anandrjs
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Syed,
Close the thread by selecting appropriate correct or help full as answer i think there is lot of good responses.
Regards
Anand
