This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I think a standard formula tool would work best in this situation since you want to create a single new field that is the product of two other fields.
The multi-field formula tool is useful if you want to apply an operation across many fields at once and only specify the formula once. For example, let's say i have 20 fields of numeric cost data in a foreign currency and I want to multiple all of them by the same factor to convert all 20 to my domestic currency- that's where the multi-field formula tool would be handy.
In fact I do have sets of e.g. 10 (sometimes more) variables v1, v2, ..., v10 which I have to process in several steps, each time resulting in 10 new variables v1_new, v2_new, ..., v10_new. Usually the Multi-Field tool works pretty good for this. But in some cases I need to include in the calculation of the new variables other corresponding variables like v1_faktor, v2_faktor, ... v10_faktor.
Currently I use the normal formula tool typing the same formula (v1_new = v1 * v1_faktor) 10 times. But I'm sure there must be a better and more fail-safe way to do this.