Static Correction on one Single ROW that is a Custom measure + ending Zeros in Decimal/Custom formatting

Hi,

the eazyBI Support Team helps me so much with the setup of an report.

Now I`ve got some little Questions regarding the “formatting” of my report.

  1. I use a cusom measure to calculate hours booked on some Epics (All Epics where “Buchungsknoten” ist not “none”

    Sum(
    Descendants([Epic Link].CurrentMember,[Epic Link].[Epic]),
    CASE WHEN
    [Epic Link].CurrentMember.get(“Buchungsknoten”) <> “(none)”
    THEN
    DefaultContext(
    ([Measures].[Std. benötigt dez.],
    [Buchungsknoten].[Buchungsknoten].GetMemberByKey(
    [Epic Link].CurrentMember.get(“Buchungsknoten”)),
    [Epic Link].DefaultMember
    )
    )
    END
    )

One Row have to be displayed with a correcting value e.g.

336,68 is given/Imported
253,58 should be substracted in the Report

I thought i can do that with an ELSE in this Calculated measure:

Sum(
Descendants([Epic Link].CurrentMember,[Epic Link].[Epic]),
CASE WHEN
[Epic Link].CurrentMember.get(“Buchungsknoten”) <> “(none), (A40800-053-010)”
THEN
DefaultContext(
([Measures].[Std. benötigt dez.],
[Buchungsknoten].[Buchungsknoten].GetMemberByKey(
[Epic Link].CurrentMember.get(“Buchungsknoten”)),
[Epic Link].DefaultMember
)
)
ELSE
DefaultContext(
([Measures].[Std. benötigt dez.] - [253,58],
[Buchungsknoten].[Buchungsknoten].GetMemberByKey(
[Epic Link].CurrentMember.get(“Buchungsknoten”)),
[Epic Link].DefaultMember
)
)
END
)
)

  1. I want to Display the “€” behind some Imported values. I created a custom measure, custom format it to “##,###.## €”

That looks fine on every Value that like “250,345.35” but values like “250,345.30”

are shortend like “250,345,3 €”

Thanks in Advance for your help on that!

regards,

Jan

Hi @jan-hendrik_woecht!

For the first question there are two syntax problems:

  1. The <> operator compares exact values. Adding one more value behind comma will not work. You need to put the OR in there.
  2. In the ELSE condition, you should subtract the value from the whole result, not within the tuple.

Please try the following:

Sum(Descendants([Epic Link].CurrentMember,[Epic Link].[Epic]),
CASE WHEN
  [Epic Link].CurrentMember.get('Buchungsknoten') <> '(none)' OR 
  [Epic Link].CurrentMember.get('Buchungsknoten') <> 'A40800-053-010'
THEN
DefaultContext((
  [Measures].[Std. benötigt dez.],
  [Buchungsknoten].[Buchungsknoten].GetMemberByKey(
  [Epic Link].CurrentMember.get('Buchungsknoten')),
  [Epic Link].DefaultMember
))
ELSE
DefaultContext((
  [Measures].[Std. benötigt dez.],
  [Buchungsknoten].[Buchungsknoten].GetMemberByKey(
  [Epic Link].CurrentMember.get('Buchungsknote')),
  [Epic Link].DefaultMember
)) - 253.58
END
)

For the second question, the # means that the value is not mandatory. Please try the following custom formatting: #,##0.00 €.

Lauma / support@eazybi.com

1 Like

Hi,

thx! The Issue with formatiing “ending zeros” is done!

The first formula doesn’t work for me, the values are the same as before.

It seems, that the “ELSE” tree is not entered. When the CASE matches both, the first one will match, the second is not tryed?

I think I Try with an “AND” instead of the “OR” --> That worked!

Thank you for you’re time, this community/support ist great!

1 Like