Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 Poh
		
			Poh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 hardikpatel172
		
			hardikpatel172
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		What is count(date) here? 
3. vPStart - variable for previous period start date (vStart - count(date))
4. vPEnd - variable for previous period end date (vEnd - count(date))
you can try just putting $(vPStart) and $(vPEnd) in a separate textbox just to see what values are being evaluated for those variables. 
 Poh
		
			Poh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
I was thinking count(date) will count the number of days between the start and end (when a filter is applied).
With regards to your suggestion, I have split it up to 2 separate text bos but it doesnt seem to be working.
 hardikpatel172
		
			hardikpatel172
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		What I was suggesting is steps to troubleshoot and I will suggest that first get those two variable working PStart and PEnd and I still didn't understand how exactly you want those? 
First, try to decide what values are expecting for PStart and PEnd and how will you calculate those manually based on your selection? That would make things easier for you to define the logic for those variables. 
Feel free to share a script or screenshot of how you want and I'll be happy to help!
