SELECT * FROM projects WHERE ID = '#Form.projectid#' SELECT * FROM projects WHERE AgentID = '#Client.AgentID#' AND UnitType = 'P' Send Invitations - Project Wizard
Select the Project

Select the Promotional Project from which you want to deduct units for the contacts you invite to take an assessment.

You have #NumberFormat(GetProjects.RecordCount, '9,999')# Promotional Projects. 
 #GetProjects.ProjectName#