Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a distinct count condition if certain conditions are met.
The conditions being, [Previous Months Open Count] = 1, [No Date Closed Task] = 0 and the date(opened) < monthstart(today(),number)
Can someone please help me create this expression?
May be this:
Count(DISTINCT {<[Previous Months Open Count] = {1}, [No Date Closed Task] = {0}, opened = {"$(='<' Date(MonthStart(Today()), 'DateFieldFormatHere'))"}>} FieldName)
Here replace FieldName with whatever you are counting. and DateFieldFormatHere with whatever you opened date format is.
Best,
Sunny
Thank you for the response although it isn't getting the proper count.
Can you elaborate on what is a proper count? Share a sample?
I am trying to mimic this excel sumif statement.
=SUMIFS(Tasks!$X:$X,Tasks!$A:$A,$B$6,Tasks!$B:$B,$B7,Tasks!$Y:$Y,1,Tasks!$AA:$AA,0)
X refers to count column which consists of 1's which are summed based on other paramaters
B6 refers to a specific manager
B7 refers to an assignment group
Y refers to Previous Months Open Count which should be set at 1
AA refers to No Date Closed Task which should be set at 0