09-21-2012 09:12 AM
I have a sample data set to make it easy for you to look and know how the data looks like. The data has 3 fields 1.clientid 2.Date 3.Balances. The real data has information for the period July 2011-july2012, meaning Client balances data for the 13 months July 2011-july2012.
I want to calculate for clients who have a relationship<1 year (/*so should we first take clients whose balances do not run for full 12 months or 365 days*/- comment) with the bank,
Problem 1:Then for the clients who have relationship<1year, i want to do the following calculation.
step2.plug the value calculated in step1 into the blank data points between 2 dates
09-21-2012 09:46 AM
I see you are a Newbee. Suggestion: Select a forum, appropriate for your request, before selecting "start a discussion". That helps the responders with organization and time management. I would think both of these would go in either of the first two forums.