Skip to Content
0

Problems building a formula

May 15 at 12:50 PM

30

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A May 16 at 07:55 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded