Hi,
I am importing data from excel into a collection and the data is split into quarters. I wish to add together all those that are Q1, then move onto split all those in Q2 and then add these to a collection which will have the updated totals for each quarter.
ie:
Q1 £250
Q1 £10
Q1 £120
Q2 10
Q2 100
becomes
Q1 £380
Q2 £110
I have put in a loop and it works for the first calculated quarter but then messes up after that. Can anyone help?
I am importing data from excel into a collection and the data is split into quarters. I wish to add together all those that are Q1, then move onto split all those in Q2 and then add these to a collection which will have the updated totals for each quarter.
ie:
Q1 £250
Q1 £10
Q1 £120
Q2 10
Q2 100
becomes
Q1 £380
Q2 £110
I have put in a loop and it works for the first calculated quarter but then messes up after that. Can anyone help?