Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
My formula is below, how would I write Set expression?
=((table1 expession/table2 expression)*1000*(#ofdays in year))/#ofdays in month field1
 
					
				
		
On what do you need Set Analysis? Set analysis is analogus to WHERE in SQL.
Regards,
Kiran
 
					
				
		
I'm filtering my variables in my expression in my pivot table. I read that Set analysis was most efficient way to calculate. I'm not sure how to write my formula using Set analysis syntax.
 
					
				
		
 IAMDV
		
			IAMDV
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Please can you post the sample QV App. with your original expression? Also, it will be good to give more details on what you wanted to acheive. I can work this one for you...
Cheers - DV
