Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the attached. I'm needing help with an expression. I would like to count id when Status = Open, AssignDate is not null. AND when the ENDDate_YYYYMM = The StartDate_YYYMM. See excel attachment for expected results.
=If(STARTDATE_YYYYMM >= Max(TOTAL STARTDATE_YYYYMM, 6), Below(RangeSum(Below(Count({<Status = {'Open'},[Assign Date]-={''}>}ID), 0, NoOfRows() - RowNo() + 1))) + Count(ID))
//counts all open and closed of the current month
Is this for both sections of the expressions or one of the two?
1) Below(RangeSum(Below(Count({<Status = {'Open'},[Assign Date]-={''}>}ID), 0, NoOfRows() - RowNo() + 1)))
2) Count(ID)
Both of my expression are not representing what I want displayed.The expression that I pasted above is for the bar chart only.