New to the community and wanted to try a different path.
1) Summarize Tool: Identifies the highest number that we need to calculate a factorial for. I call this number Max
2) Generate Rows Tool: Create "Max" number of rows (this would allow the calculation of every factorial in the series in the event that the number was higher than 10)
3) Multi-Row Formula: Calculate the factorial in the next column by multiplying the previous factorial by the Number
4) Join: Collect the Factorial values for every number requested in the table.
I had a few questions following this workflow.
- Is the join tool computationally expensive? This workflow calculates all the factorials we need first to minimize the multiplications and then selects only the values that were in the initial query. If using the join tool is more computationally expensive than a multiplication there is probably a better way to do this.
- Is there a way to calculate the first row in the series without using an "If" statement? The "IF" statement is only needed to generate the first value and wouldn't be needed if you could start the calculation on Row 2.
