BusinessObjects Board

How to get data for Prior Year Full Month

building reports desktopintelligence
#1

Hello I have a report that takes a date as a prompt and brings in the data for the month. I need to bring in the last year same month as prompted by user.

This is the code I have

=Sum() Where(=)

Invoice Part Dollars is a measure
Prompt Inv Date is a dimension which has values like 1/1/04 etc
Prior Year Month is a dimension which has values like 1/1/04 Etc.

When I have this formula I get a syntax error. Can someone please help

ddsrini (BOB member since 2004-06-23)

#2

You are better off with a solution in the universe than at report level.
What RDBMS are you reporting against?
A CASE statement is the usual solution for Oracle or SQL Server databases, together with your prompt.

Regards,
Mark

#3

Regarding a work around for the WHERE clause in Business Objects Reporter, please see this Reporter FAQ entry.

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