Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
What could be wrong with the following expression:
=Num((Sum({< [Date Dispensed] = {'>=$(=Date('2013-09-01'))<=$(=Date('2014-08-31'))', [New Product Indicator]={'YES'} >} [MedAid Amount] + [Shortfall])), '$##,##0.00')
Regards
 
					
				
		
 swuehl
		
			swuehl
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You are missing a curly bracket } and probably the sequence of single quotes will not be parsed correctly by QV.
Use a combination of double and single quotes instead.
=Num((Sum({< [Date Dispensed] = {">=$(=Date('2013-09-01'))<=$(=Date('2014-08-31'))"}, [New Product Indicator]={'YES'} >} [MedAid Amount] + [Shortfall])), '$##,##0.00')
Then take care that the default date format matches the format of [Date Dispensed] and that your default number separators are matching your num() format code. If in doubt, specify the Date() format code and the num() separators explicitely.
 
					
				
		
 swuehl
		
			swuehl
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You are missing a curly bracket } and probably the sequence of single quotes will not be parsed correctly by QV.
Use a combination of double and single quotes instead.
=Num((Sum({< [Date Dispensed] = {">=$(=Date('2013-09-01'))<=$(=Date('2014-08-31'))"}, [New Product Indicator]={'YES'} >} [MedAid Amount] + [Shortfall])), '$##,##0.00')
Then take care that the default date format matches the format of [Date Dispensed] and that your default number separators are matching your num() format code. If in doubt, specify the Date() format code and the num() separators explicitely.
 maxgro
		
			maxgro
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		=Num(
(Sum({<[Date Dispensed]={">=$(=Date('2013-09-01'))<=$(=Date('2014-08-31'))"}, [New Product Indicator]={YES}>}
[MedAid Amount] + [Shortfall])), '$##,##0.00')
 
					
				
		
Thank you will check
 
					
				
		
Thank you will advise accordingly
