BusinessObjects Board

How to define Quarter days

I have a predeined variable “Bucketts” with the following formula that is not populating the data correctly.
= If (<CurrentDate()) Then “Past Due” Else If(>CurrentDate()+180)Then"Future"Else (+" QTR "+)
I am having same $amount in Past due and Currnt Quarter. So I am trying to define a variable that fetches the data from April17,2004 to June17,2004. I am getting syntax error while defining the varible X
.=Sum() Where MonthsBetween(‘4/17/2004’ ,‘6/17/2004’)
( My intention is to get the open order amt for the dates between Apr17 & 6/17, based on custer Request date.
Any tips??
regards,
padmaja


padmaja (BOB member since 2002-09-19)

You would need to define the variable at the lowest grain of the data, i.e create a variable that would say “Y” if the customer request date between 4/17/2007 and 6/17/2004 and “N” otherwise. Then create another variable that would be sum(open ord amt) where =“Y”.

Hope this helps…


Anjan Roy (BOB member since 2002-07-10)

Please, look at this post under FAQ Reporter.


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