Value of Customfield in specific issues

Questions & Answers
1

Hi,

i have the following fields which I need to include into a report:

  • multiselect-Field “Standardgeschäftsfälle” (selected Option in this
    example is “SG 2a Text layoutieren - Word”
  • numbers-Field “Preis SG2”
  • date-Field “Abrechnungsmonat”

So what needs to be done is, if the option of “Standardgeschäftsfälle” is selected and the date field matches the current month, then the result should be the current Value of “Pries SG2”.

What i tried is:

CASE WHEN(
IIf( – (,,)
DateInPeriod(
[Issue].CurrentMember.get(‘Abrechnungsmonat’),
[Time].CurrentHierarchyMember),
(Aggregate(
{Filter([Standardgeschäftsfälle].[SG 2a - Text layoutieren - Word].Siblings,
[Standardgeschäftsfälle].CurrentMember.Name MATCHES “SG 2a - Text layoutieren - Word”)}
)),
0
)
) > 0
THEN
Aggregate(
{[Standardgeschäftsfälle].[SG 2a - Text layoutieren - Word]},
[Measures].[Preis SG2 history]
)
END

The part in strong letters alone returns the correct issues. But if I add the measures to get the Value of the “Preis SG2” Field, all Issues where “[Standardgeschäftsfälle].[SG 2a - Text layoutieren - Word]” was selected alongside other options, are not shown. (It does however work, if I select each option individually and then update the issue)

Can anyone enlighten me why this is the case and how to solve it?

kind regards,
Maximilian

2

Hi,

We would need to see a screenshot or the report definition for proper guidance on this request.

Kindly,
Janis, eazyBI support

3

Hi,

the issues solved itself as it was occurring due to some - still unknown - bug which made values “invisible” for eazy_Bi. Same goes for other Addons so the error was not on your part :).

Thanks for looking into it though.

Maximilian

1 Like