Skip to Content
avatar image
Former Member

webi: reference filtered cell value

Hello,

I'm working with SAP BO WebIntelligence and have a filtered block outputting a value of 30 (filter is reducing total from 590 (restricting to the last 31 days)).

Is it possible to reference the value of this cell (30) in the below text formula?

=If(NumberOfRows([print]) = 0) Then "No print books purchased this month." Else ([print].[Total items]) + " total print books purchased this month."

The cell formula is:

=Sum([print].[Total items])


The output is always the unfiltered result of 590. Is there a way I can get my filtered result of 30 referenced outside of the filtered block?

Thanks for your time and assistance,

Joe

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 25, 2017 at 08:08 AM

    is there any filter applied on the table where total values are coming 30.if yes add those filter in the where clause to get 30.

    Add comment
    10|10000 characters needed characters exceeded