Skip to Content
0

While creating WEBI Reports, two different formulas are giving same value.

Feb 14 at 10:37 PM

58

avatar image
Former Member

Version :- SAP BO 4.0 sp4

Hi Everyone!

Here i am creating few webi reports containing finance related data (e.g balance sheets, Profit and Loss etc.)

Backend of these report are BEX Queries (BW 7.3)

While writing formulas for the cells i am getting same value for two different formulas.

E,g

1. =([Balance Sheet].[Cummulative Balance Current Year] Where( ([Balance Sheet].[0GL_ACCOUNT__LEVEL2].[0GL_ACCOUNT__LEVEL2 - Key]="ADVANCE TAX (NET)") ) ForEach([Balance Sheet].[0GL_ACCOUNT__LEVEL2].[0GL_ACCOUNT__LEVEL2 - Key]))

2. =([Balance Sheet].[Cummulative Balance Current Year] Where( ([Balance Sheet].[0GL_ACCOUNT__LEVEL2].[0GL_ACCOUNT__LEVEL2 - Key]="INTANGIBLE ASSETS") )) ForEach([Balance Sheet].[0GL_ACCOUNT__LEVEL2].[0GL_ACCOUNT__LEVEL2 - Key])

These two formulas are giving same value, simlilarly for other cells also report is misbehaving, while Bex output showing correct(Different values).

Thanks in advance.

10 |10000 characters needed characters left characters exceeded

Hi,

Try this

=([Balance Sheet].[Cummulative Balance Current Year]) Where( [Balance Sheet].[0GL_ACCOUNT__LEVEL2].[0GL_ACCOUNT__LEVEL2 - Key]="ADVANCE TAX (NET)") IN ([Balance Sheet].[0GL_ACCOUNT__LEVEL2].[0GL_ACCOUNT__LEVEL2 - Key])

or try taking out context operator from the formula.

= ([Balance Sheet].[Cummulative Balance Current Year]) Where( [Balance Sheet].[0GL_ACCOUNT__LEVEL2].[0GL_ACCOUNT__LEVEL2 - Key]="ADVANCE TAX (NET)")

Thanks,

Jothi

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers