Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Created Date is field used in expression.
this exp am using right now
=Count(Aggr(Created Date<=Today()+60 and StatusName<>'Closed',IssueID))
Hi Chanty
I have a query regarding your formula
Why are you adding 60 days to your date.
Are you creating ids with future dates??
Do you still see the red line if you remove the negative sign in front of equal?
yes sunny.
that is very strange, can you copy and paste the expression here. Just want to check if we have all the brackets (curly, square, parenthesis) in correct place.
=count({<[created Date]={'<=$(=Today()+60)'},RiskIssueStatusName={'Closed'}>} RiskIssueID)
and tried this also but no use
=Count(aggr(if(Created Date<=Today()+60 and RiskIssueStatusName<>'Closed',RiskIssueID)))