I have a commissions gallery where each record in the gallery is pulling from my main commissions database, all works well.
I put a text label in the gallery record and do a calculation Amount * Commission Rate and get a value to pay the sales rep.
I would love to add a 2nd text label called Running Balance that starts with the first item in the gallery and keeps a running total as you move down the gallery items as a balance. So if the first record was pay $1000, the balance would be $1000. The next gallery line would maybe say pay $500, the balance label would say $1500 (Prior balance of $1000 plus current item of $500) and so on....
Is this possible?

Report
All responses (
Answers (