Comparing measures using '=' operator

Questions & Answers
1

I am trying to find all the issues which have the same value in a field as their parent. For example: a ticket which has value “X” is field F and whose parent also has value “X” in its field F.

To do this I am getting both the field values and using the ‘=’ operator to check if they are the same insde the filter method.

When I try to do this, this error is shown:
#ERR: mondrian.olap.fun.MondrianEvaluationException: Expected value of type NUMERIC; got value <value of the parent’s field>

Seems this is occurs when the ‘=’ operator is used to compare 2 values returned from a dimension (Ex: [Measures]/[Issue] etc).

Is there a work around to this bug?

2

Hi @SaVer ,
Can you share your formula and values that are used in those fields?

One of the guesses is if you are using issue properties, you can try using the function .getString(), instead of .get() and then compare values with the operator “=”
Like this:

[Issue].CurrentHierarchyMember.GetString('issue customfield') = 
[Issue].CurrentHierarchyMember.GetString('issue parent customfield')

best,
Gerda // support@eazyBI.com