Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have discussed previously the issues I was encountering for my InQuarter count and I thought it maybe be easier to start fresh.
I am looking to count the number of activities by quarter depending on the what Year the user has selected. I am using 2015 & 2016 data only and cannot get it to change result when the year selected changes. Below is what I am currently using. Many thanks.
=(Count(Distinct If ( [Activity.Status]='Completed' AND InQuarter([Activity.Completed Date], Yearstart(Today()), 0), [Activity Id], )
Which Quarter's value would you like to see here? Quarter 1 or all Quarters?
Hi Sunny,
I would like 4 separate List Box Properties - one for Q1, a second for Q2 etc
Could you share sample data ?
Does this make sense? Or should I take a different approach?
As per sample below.
may i know why your using the Yearstart in your expression because it always starts your date with the 01-01 for that year so it always corresponds to that particular Quarter or Q1. could you please elaborate bit more on this