hii i need to calculate the closing balance for a particular month which has the following formula : closing bal=Prior Period Balance + Opened in Current Month Closed in Current Month where current month is assumed to be the month for the date which is selected by user in the prompt.
Could u help me for the same.
BO_USER1 (BOB member since 2011-03-27)
What does your table look like? Are these fields defined? Are you facing any particular problem while defining this formula?
nithya_raj (BOB member since 2007-02-03)
hi BO_USER1,
can you please elaborate more like:
whether closing bal,Prior Period Balance all these values stored in individual objects or you mean to say from the transaction we have to calculate.
And yes there should not be challenge to calculate the current month from value entered by user.
Proper use of User Response and to date will be able to do it .
swap_l (BOB member since 2009-04-09)
Sorry …I should have been more elaborate… Actually I need to calculate all the values ie. prior balance, open in current month and closed in current month … where the prior balance should give me all the data before the beginning of the current month
BO_USER1 (BOB member since 2011-03-27)
You need to describe your data before anyone can advise on how to proceed. It would also help if you describe how you want the report to be presented on screen.
BTW elaborate (elabor 8) and elaborate (elaborat) are annoying homonyms. The verb ‘to elaborate’ means to provide more explanation on a topic. The adjective ‘elaborate’ means something that has a complex structure. 
English you have to love it 
dfoster99 
(BOB member since 2010-11-05)
@BO_USER1: Based on what fields in your database should you define the formula for prior balance, open in current month and closed in current month? Could you share the fields and the formulae that you are trying to achieve?
nithya_raj (BOB member since 2007-02-03)
I have used 2 queries wherin in one of them i have dragged objects related to created date ie incidents created and in other all objects related to closed date ie. incidents closed… I am able to find the open balance using the formula
Count([Open Across Month].[Incident Number]) ForEach ([Created Month Of Year])
wherein Created month of year and incident number are dimension objects. And the incident number comes from the data provider Open Across Month.
Simillarly i have done it for closed balance as well.
Now I need to find prior balance for the last 12 months ie. all the incident that were not in closed or resolved state before the beginning of that month.
so help me to find prior balance
BO_USER1 (BOB member since 2011-03-27)