BusinessObjects Board

How to count the number of <whatever> between two date

I have a variable called whose formula is:

- Mod(DayNumberOfWeek() + 1 , 7)

Where is the calendar date from my Date table.

I need to count the number of applications between and + 7 Days.

I thought I could use:

Count() Between ( , RelativeDate(,7))

But it returns an “Incorrect Data Type (DMB00003)” error and places the cursor at the end of my formula.

Am I doing something fundamentally wrong? :confused: I’m thinking this should be an easy task.

Thanks!


SeanB (BOB member since 2004-02-11)

Try:

Count (...) WHERE ( ...)

And see the FAQ Reporter Entry:


Andreas :de: (BOB member since 2002-06-20)