Skip to Content

Problems building a formula

Hi All,

I am working with "SAP BusinessObjects Business Intelligence 4.2" and have the following problem.

This formula is accepted by Webi, but it does not give me the expected results:

I receive the expected values of 0 and 1, but as soon as I use another formula with the variable [MAX_INM_AGR_EffDurationOla1], I receive an error:

=Sum([MAX_INM_AGR_EffDurationOla1])


I receive the #MULTIVALUE error and have no idea for what reason ...


Can you help?


Regards,
Henning

hx4vy.png (13.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 16 at 07:55 PM

    Hi,

    [INMttdId] dimension might have multiple values.

    Drag and drop that dimension and you will the detail level of data.

    try: =Sum([MAX_INM_AGR_EffDurationOla1]) IN ( [INMttdId])

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded