Running Avg using Multi-Row tool

[EN6924]

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..

[AngelosPachis · Accepted 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