Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 jim_chan
		
			jim_chan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi guys,
I would like to write an set analysis.
i have attached screenshot.
1) i have a straight table. i have a normal expression. sum(tree_population_points).
2) i am unable to sum up correctly. It should not show 7.
3) the total sum should be 18.
so, how can i get that sum??? group by? aggr???
Rgds
Jim
It will work direct way - May be this? sum(TOTAL tree_population_points)
Or change your expression like below
It will work direct way - May be this? sum(TOTAL tree_population_points)
Or change your expression like below
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Use total mode 'Sum of rows' in the expression tab.
 jim_chan
		
			jim_chan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Yes, it has given me the correct figure.
Can you show me how to write in a set analysis??
Rgds
Jim
 jim_chan
		
			jim_chan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Yes, it has given me the correct figure.
Can you show me how to write in a set analysis??
Rgds
Jim
 jim_chan
		
			jim_chan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		i have tried with sum(TOTAL tree_population_points)
it gives me the wrong value - which is 7.
For me, It's working with simple aggregation also. Would you share sample
