Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 adiarnon
		
			adiarnon
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		hi,
i have a problem
i have a Gauge with just an expression
the expression should give -34
in the labal i see the 34(right)
but the number under 35
like in the picture -

someone know why its happening??
adi
 ashfaq_haseeb
		
			ashfaq_haseeb
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Can you provide sample Application to look over.
Regards
ASHFAQ
 adiarnon
		
			adiarnon
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		hi,
im sorry but i cant,
i dont have internet in the computer with the qlikview...
 
					
				
		
 mdmukramali
		
			mdmukramali
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		!Dear,
May be your using floor function. instead of floor use the ceil function.
Kindly find the attached sample file.

i Hope it will help you.
Thanks,
Mukram
 adiarnon
		
			adiarnon
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		hi,
om not using floor or ceil
=count({<PROJECT=>}if((aggr(Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}ActualCurrentBook_$(vFinanceFormula)),PROJECT)>0) 
and (Aggr((Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}BudgetCurrentBook_$(vFinanceFormula)))/(Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}ActualCurrentBook_$(vFinanceFormula))),PROJECT)=0),PROJECT)) 
