You can do so by wrapping your field calculations in parenthesis () and then combining these with text like:
({first field} + {second field}) & ' / ' & ({third field} + {fourth field}) & ' / ' & ...
Hope that helps!
-Stephen
You can do so by wrapping your field calculations in parenthesis () and then combining these with text like:
({first field} + {second field}) & ' / ' & ({third field} + {fourth field}) & ' / ' & ...
Hope that helps!
-Stephen
Hi @Stephen_Orr1 ,
thanks for the formula. But I do only have the first field and second field. The third and fourth field is being calculated (the result plus 10 / the new result plus 10 / etc.).
I.e.: 70 + 10 = 80 + 10 = 90 + 10
Do you know what I mean?
Thanks again,
Michael
CONCATENATE(
({field1} + {field2}) & " / ",
({field1} + (2 * {field2})) & " / ",
({field1} + (3 * {field2})) & " / ",
({field1} + (4 * {field2}))
)But note that this does not produce a true array. It produces a text string that looks like a list of items.
CONCATENATE(
({field1} + {field2}) & " / ",
({field1} + (2 * {field2})) & " / ",
({field1} + (3 * {field2})) & " / ",
({field1} + (4 * {field2}))
)But note that this does not produce a true array. It produces a text string that looks like a list of items.
Hello @kuovonne thanks a lot.
Unfortunately I got an error and I guess it is because {field2} is a formula field (although it outputs a number).
Field2 has this formula and I guess I have to convert the result to a number somehow: IF({Length} = '1 Year', '6', IF({Length} = '2 Years', '12')))
M.
---
UPDATE:
I converted the result of the formula in Field2 to a number and it did work then 😀. Thanks @kuovonne
