Based on the data I can create Running total using Multi-Row tool.
How can I create Running Average of Transaction amount using the same tool?
Need help..
Solved! Go to Solution.
Hi @EN6924 ,
You can achieve that by adding a record ID (a multi- row formula) tool and then estimate the running average by dividing your running total by the record ID
EDIT : Sorry, I missed the fact that you were grouping on TransactionID in the first multi-row formula tool. Also, I believe that you should change your running total expression to
[Row-1:Running total]+[Transaction_Amount]
Hope that helps,
Angelos