Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two date fields like CN_EDT(contracts start date) and CN_XDT(contracts end date).I have an agent and year filters. If I select one agent and year it has to display number of contracts has done by an agent in that year between these two dates.
Please help me to solve this
Thanks in advance
Anusha K
if(Year([contracts start date]) = Year and year( [contracts end date] )= Year, Count( Contracts))
create two variables to read the start and end date,
then try like this:
count({<Calender_Date={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"}>}contract )
Hi Anusha,
See the attachment.
Thanks,
AS
Try
count({<agent,year,date_field={'>$(=[contracts start date]) <= $([contracts end date])'}>}contracts)
Hi,
Try this one I hope it will work...Don't directly Copy paste this.Modify it according to your requirement.
=count({<Date={>=CN_EDT<=CN_XDT},Agent=$::Agent,Year=$::Year>}contracts)
Use Set Analysis as suggested by other community members, but keep in mind the Date Format of all comparison dates must be of same format.