Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 05 Jun 2014 at 5:11am
I have 2 ideas:
1) create a shared string that is delimited and holds both car and sum...I've used this before and for me it would look like
|BMW@3|Audi@1|
then it is all string parsing and manipulating...new values are just added to the end
the other idea is to have 2 arrays, one with the name of the car in it and the other with sum
or a melding of the 2 solutions an array with a delimited string holding the name and the sum.
you could search the array fairly easily with something like:
if left(array[x], len({table.carname}) = {table.carname} then do something.
both of the last 2 suggestions with arrays would of course be done in a for loop with variables for found etc so that new cars are added to the end.
Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Posted: 05 Jun 2014 at 6:42am
you could also try grouping on car and color then using the group heather 2 instead of details section then create a formula like sum(amount,car) for total
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum