Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 prahladind9
		
			prahladind9
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		COUNT(if(CATEGORY = 'LIABILITY' AND DATESTART>=DATEPREVFINYEARSTART, CUSTOMERACCOUNTID))
I want to convert this expression into set analysis exp.
like count({$<CATEGORY = {'LIABILITY'}>}CUSTOMERACCOUNTID)
I don't know how to complete the expression.
Please help me out.
Thanks.
 
					
				
		
 prahladind9
		
			prahladind9
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thank you.
Small thing still remaining
IF(MODULE = 'OD', AMTSANCTIONEDLCY, IF(MODULE = 'LOANS', AMTCRTURNOVERTODAYLCY))
In Set Analysis Format...
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Is this an expression or dimension?
 
					
				
		
 prahladind9
		
			prahladind9
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Expression
SUM(IF (AMTDEBITBALLCY > 0 AND (AMTTOTALODUTILIZEDLCY > AMTTOTALODLIMITLCY) and (APPLICATIONDATE = DATEFIRSTOVERDRAWN )
, AMTDEBITBALLCY - AMTTOTALODLIMITLCY))
 somacdc
		
			somacdc
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I want to following data
| FOLIO_NUMBER_UHR | TOTAL_NO_OF_UNIT_OF_UH | 
| 1 | 166633.7933 | 
| 2 | 0.3334 | 
| 3 | 0.12 | 
| 4 | 133333.3333 | 
| 5 | 2500 | 
After applying following condition Folio number 2 and 3 disappear.
ApplyMap('UH_REGISTER_MAPPING', FUND_ID &'-'& FOLIO_NUMBER, 0) >> 0
