Hello,
I used this script but getting 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)
and i tried this script and 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 ‘ AND ’
Thanks
Rohith
