Average Balance

  • Pranav
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
12 years 4 months ago #9542 by Pranav
Average Balance was created by Pranav
Friends,

I'm looking a program to generate average balance of all accounts for given start date and end date.

Can any one help me.

Regards,

Pranav.

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
12 years 4 months ago #9549 by jpb
Replied by jpb on topic Re: Average Balance
The enquiry ACCT.AVERAGE.BAL uses a routine E.ACCT.AVERAGE.BAL that should be in your GLOBUS.BP/T24.BP

:)

Please Log in or Create an account to join the conversation.

  • Pranav
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
12 years 4 months ago #9565 by Pranav
Replied by Pranav on topic Re: Average Balance
I had tried from that enquiry but not getting result.

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
12 years 4 months ago #9566 by jpb
Replied by jpb on topic Re: Average Balance
Strange.
I don't know what you expect, but here the EQ works fine.
At least you can use the routine behind to start your own development and you can see what it is really calculating...

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #9580 by DUBLIN
Replied by DUBLIN on topic Re: Average Balance
Hi,

In an enquiry , when it calls sub E.ACCT.AVERAGE.BAL it gets back a list ov values that enquiry then splits by 5 parts . Returning string format is :

CR.DAYS>CR.AV.BAL>DR.DAYS>DR.AV.BAL>ZERO.DAYS .

You can see all of them in the following fields.

Now, if you are looking for "REAL" average balance for the period all you need to do is to calculate in your enquiry the following :

ACCOUNT.AV.REAL = (CR.DAYS*CR.AV.BAL + DR.DAYS*DR.AV.BAL)/(CR.DAYS + DR.DAYS + ZERO.DAYS)
The following user(s) said Thank You: Pranav

Please Log in or Create an account to join the conversation.

  • Pranav
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
12 years 3 months ago #9717 by Pranav
Replied by Pranav on topic Re: Average Balance
Thank you Jpb & Dublin.

Please Log in or Create an account to join the conversation.

  • Pranav
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
12 years 2 months ago #10140 by Pranav
Replied by Pranav on topic Re: Average Balance
Hi Dublin and Jpb,

One more question on same issue.

If we have to extract average balance for closed accounts, what shall we do ?

e.g START.DATE = 2011 Jan 1 END.DATE = 2011 Jul 1

Now, I need average balance of all accounts closed between these two dates.

Pranav.

Please Log in or Create an account to join the conversation.

More
12 years 2 months ago #10143 by DUBLIN
Replied by DUBLIN on topic Re: Average Balance
Hi,

I don't think it does matter is accout closed or not , routine should work anyway .

Please Log in or Create an account to join the conversation.

  • Pranav
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
12 years 2 months ago #10146 by Pranav
Replied by Pranav on topic Re: Average Balance
Hi,

Actually once account is closed, account move to history file and this routine uses only account file not history file.

If it should work, I will try with using account history file by selecting closed accounts records.

Please correct me, If I need to modify any else.

Thanks,

Please Log in or Create an account to join the conversation.

More
12 years 2 months ago #10151 by DUBLIN
Replied by DUBLIN on topic Re: Average Balance
Hi Pranav,

I think you are on the right way, generally ... All u need to do is to build a combined list of "LIVE" and "D..d" , sorry, "CLOSED" accounts. How to do it ? It's your choice ;) Sounds like you need a routine to build a selection list ... And I wouldn't go "ACCOUNT$HIS" way ...

ACCOUNT + ACCOUNT.CLOSED should work better unless there are some surprises ...
You don't need to use NOFILE either.

Please Log in or Create an account to join the conversation.

Time to create page: 0.116 seconds