Issue filter for Open issues with start date < today

Rohith reddy April 10, 2023

Hello, 

I used this script but geeting error as below. Can anyone help me out?

Sum(Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),
[Measures].[Issue start date] < [Measures].[Today]

),
[Measures].[Issues created]
)

#ERR: mondrian.olap.fun.MondrianEvaluationException: Expected value of type NUMERIC; got value 'Wed Jul 07 00:00:00 UTC 2021' (DATETIME)

 

1 answer

0 votes
Rohith reddy April 10, 2023

I am also getting an error for this script 

Sum(Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),
[Measures].[Issue start date] < [Measures].[Today]
AND
[Measures].[Open issues]
),
[Measures].[Issues created]
)

Error - Formula is not valid:
No function matches signature '<Logical Expression> AND <Member>'

Suggest an answer

Log in or Sign up to answer