Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed 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

  • Get RSS Feed

0 Answers