I have a csv dump from our financial system that gives me financial data for each account code. The account code contains expense elements which in turn are grouped to Expense Groups. For example, a 10 digit account code has the last 3 digits as an expense element. That expense element can be classified in a group such as Consumables, Labour, etc. What I need to do is the following:
- Isolate the expense element for codes that are only 10 digits or longer (I guess this is a count function, then a right function)
- Total the charges for each month by expense group. That is, if an expense element belongs to a certain group, the costs for one month will be added to the costs for the same month for all other expense elements in that group.
- Now here is the tricky part. I also have a hierarchy, so I only want to do the second part for EACH HIERARCHY. When the data is dumped in the csv format, there is actually a break between hierarchy codes. I want to be able to recognise where a hierarchy code begins and ends and summarise the expense group costs for each hierarchy.
Am I trying to do too much? Please tell me I'm not. It would be so much easier doing this with a single csv file, than the alternative (minimum 12).
- Isolate the expense element for codes that are only 10 digits or longer (I guess this is a count function, then a right function)
- Total the charges for each month by expense group. That is, if an expense element belongs to a certain group, the costs for one month will be added to the costs for the same month for all other expense elements in that group.
- Now here is the tricky part. I also have a hierarchy, so I only want to do the second part for EACH HIERARCHY. When the data is dumped in the csv format, there is actually a break between hierarchy codes. I want to be able to recognise where a hierarchy code begins and ends and summarise the expense group costs for each hierarchy.
Am I trying to do too much? Please tell me I'm not. It would be so much easier doing this with a single csv file, than the alternative (minimum 12).