BusinessObjects Board

Year to Date sum when data available for more than 1 year

building reports desktopintelligence
#1

I would like to do

Sum( where =Year(CurrentDate()))

It does not allow me to do this. I can only do this

Sum( where =2003)

And I do not want to hard code the year like that.

ANy ideas?

Appreciate all your help.

Thanks,
ABV

ABV (BOB member since 2003-06-20)

#2

Please, look at the Reporter FAQ - this very same problem with workaround has been discussed there :wink:

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

#3

Thanks a ton.

That was helpful

Regards,
ABV

ABV (BOB member since 2003-06-20)