Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 ssriramin19
		
			ssriramin19
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I have a expression which is given in background color .
=IF(MthNbr>=num(month(date#(month(today()),'MMM'))),Yellow())
There is another field called DP_LAG .So my requirement is that whenever DP_LAG is selected the values above color expression should not change.
what is happening right now is that when DP_LAG is selected color range from the above expression is not getting active. How to accommodate set analysis {<[DP_LAG]=>} in the above color expression so that when DP_LAG is selected color will not change.
Please suggest some method on this.
Thanks
Sriram
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try this may be:
=If(Only({1} MthNbr)>=Num(month(today())), Yellow())
=If(Only({<[DP_LAG]=>} MthNbr)>=Num(month(today())), Yellow())
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try this may be:
=If(Only({1} MthNbr)>=Num(month(today())), Yellow())
=If(Only({<[DP_LAG]=>} MthNbr)>=Num(month(today())), Yellow())
 ssriramin19
		
			ssriramin19
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks very much on needed suggestion. It is working as expected.
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		No problem 
I am glad it worked as you wanted.
Best,
Sunny
