There's a common need to perform the same function on many fields, where you want to bring in data from a secondary field which is defined by the current column name.
So - for example:
Input:
- Prod1UnitWeight: 10
- Prod1Qty: 10
- Prod2UnitWeight:15
- Prod2Qty: 1
Output
- Prod1TotalWeight: 100
- Prod2TotalWeight: 15
So it would be useful to be able to have an indirect function where you can create a string which contains the field you want to use; and then indirect to it.
For example:
- Multi-field formula on Prod1Qty; and ProdQty
- CreateNewField Prod1TotalWeight
- [_CurrentField_] + indirect(replace([_currentFieldName_],"Qty","UnitWeight")
- which would resolve to prod1Qty * indirect("Prod1UnitWeight")