BusinessObjects Board

Where function doesn't work with variable.

building reports webintelligence legacy
#1

Hey, hopefully someone can help me.

I’m building a report and i’m stuck with a formula. For just one cell i have the formula:


=Count([Cust].[CustomerNumbers] Where([Cust].[Yearweek]=[PreviousWeek]))

The formula of [PreviousWeek] works in other sections and gives the value “201710” as a number.

The formula stated above gives “0” because of the reference in the Where clause. If I edit [PreviousWeek] to “201710” (without quotes) it works and gives me the right value. The problem is that I don’t want it hardcoded. I need to get the formula to work :frowning:

Can anybody help me with this?

ndam (BOB member since 2016-11-09)

#2

I already found a solution :slight_smile:

I’ve made another variable which counts the amount of customer numbers where the count formula was for.

When changed to the formula below it worked.

=[#Customers] Where([Cust].[Yearweek]=[PreviousWeek])

ndam (BOB member since 2016-11-09)