Add constant to each item in list

[EFcoder]

Is it possible to add a constant to each item in a List such that:

List(1, 4, 😎 + 6 becomes

List(7, 10, 14)

Thank you.

[1minManager]

No. If the 1, 4 & 8 are in a table then I’d suggest adding the 6 there and then pulling in that new figure as a list.

The only way I can think of how to do it as you describe would be to pull out each item, add 6, then merge to make a new list:

LIST(
	INDEX(List(1, 4, 8),1)+6
	,
	INDEX(List(1, 4, 8),2)+6
	,
	INDEX(List(1, 4, 8),3)+6
)

Simon@1minManager.com

[EFcoder]

Thanks Simon