Help regarding Quarters(Month)

[Chic0]

I am having problems regarding Quarters in Business Objects 5.1.3.

I am using an SQL query to return some values from a table, one of them being 'MONTH'. As month is being returned, Business Objects automatically generates a 'QUARTER(THE_MONTH)' variable.

I am using the 'QUARTER(THE_MONTH)' variable as part of my report but it is not the correct value. At the moment the value displayed is worked out by adding all the values for that quarter together. What I need to be displayed is the value as of the last day of the Quarter.

I would be really grateful if anyone can help/assist me on this matter.

Thanks

 

[skrandel]

You can't do this with a simple query. These are snapshots. As a result, you need ending balances, not sums. Do a search on busobj.forumtopics.com for "ending balance" or "last" and see what comes up.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com

 

[Sridharan]

Apart from that if you can show us you sample data and what you are looking out for maybe we can help you.

Sri