B
Brendan Hanrahan
I have been working on this all morning and I can't seem to get it...
I want to get a single total for each account number when my data has
a random distribution of accounts
for example:
Account Balance Total Owed (what I want/can't figure out)
A100 1 1
A101 2
A101 1 3
A102 3 3
A103 2 2
A104 2 2
A105 3
A105 3
A105 4 10
I haven't been able to combine a logic function with a nested sum to
make this happen, Any ideas?
Brendan
I want to get a single total for each account number when my data has
a random distribution of accounts
for example:
Account Balance Total Owed (what I want/can't figure out)
A100 1 1
A101 2
A101 1 3
A102 3 3
A103 2 2
A104 2 2
A105 3
A105 3
A105 4 10
I haven't been able to combine a logic function with a nested sum to
make this happen, Any ideas?
Brendan