Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 stabben23
		
			stabben23
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi I have a variable 'vNetSales' sum(Value), when I use this in a Bar chart in the expression like $(vNetsales)/1000 nothing happens, the value wont get divided. This is not a problem, I can use sum(Value)/1000 in my expression but I wondering why this dont work.
//Stabben
 
					
				
		
did you managed to make it work? I have the same issue.
 
					
				
		
 nizamsha
		
			nizamsha
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try this one
='$(vNetSales)'/1000
 
					
				
		
Still not working thx, hope somebody can give me a clue ...
 
					
				
		
Did you write correctly your expression ? QV is case sensitive (take care)
because that is correct:
I have done v1 - Sum(Sales) in Variable Overview window (no = sign to get an interpretation for all rows)
In the expression, I have done
$(v1)/100 or $(=v1)/100 : both work perfectly
(no quotes)
Fabrice
 
					
				
		
in the end in my example where my variable (vA) defined an expression using variable. My solution that worked was $(v1)/$(=$(vA)) Thank you for your posts it helped my thinking....
