Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi,
I have KPI descriptions in a list box and their corresponding id's are available in the data.
When user selects multiple KPI descriptions then we need to perform set analysis based on descriptions/or id' selected.
Example: user selects 5,7,9 kpi descriptions then it should convert like Sum( { KPI5 } Values)+Sum( { KPI7 } Values)+Sum( { KPI9} Values)
How to write set analysis dynamically for this scenario.
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Might be easy to understand if you are able to share a sample
 
					
				
		
 varshavig12
		
			varshavig12
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Sum of Values based on KPI:
sum({$<KPI>}Values)
OR
Sum of IDs, based on KPI_description:
sum({$<KPI_description>}IDs)
