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)
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>'
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.