Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi,
I have sum(Amounts) column as a Expression. My requirement is,
if sum(Amounts) has negative value , that negative value should be Red Color and that negative value in brackets like ( ).
How can i achieve this, could you please tell me Set expression and process
Thanks,
MLNR
 
					
				
		
 jagan
		
			jagan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Use this as expression
=Num(Sum(Sales), '#,##0.00;(#,##0.00)')
and in number table select Expression Default option.
and for background color expand + sign of the expression and click on Background and give below expression
=If(Sum(Sales) > 0, RGB(255, 0, 0))
Hope this helps you.
Regards,
Jagan.
 
					
				
		
 senpradip007
		
			senpradip007
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try this
if(sum(Amounts) >=0, sum(Amounts), '(' & sum(Amounts) &')' )
Expend expressions and write the following expression "Background Color" section for background
if(sum(Amounts) <0, red(), black())
 
					
				
		
Hi Jagan,
Thi expression is ok. But I want , negative number color is in red and negative number should be in brackets like ( ).
Thanks
MLNR
 
					
				
		
Hi Pradip,
Thi expression is ok. But I want , negative number color is in red and negative number should be in brackets like ( ).
Thanks
MLNR
 
					
				
		
 sunilkumarqv
		
			sunilkumarqv
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Make use Expression as Num(sum(Amount),'#,##.#;(#,##.#) ; '))
and then go to + sign background expression
IF(Sign(Amount)='-1',Red())
 
					
				
		
 senpradip007
		
			senpradip007
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Have you tried it?
 
					
				
		
 jagan
		
			jagan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
For coloring try like this
For Text color expand + sign of the expression and click on Text Color and give below expression
=If(Sum(Sales) > 0, RGB(255, 0, 0))
Regards,
Jagan.
 
					
				
		
 senpradip007
		
			senpradip007
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Have a look on the attachment.
 
					
				
		
Hi Narayana ,
Pradip Sen suggested is working
