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
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.