I was getting a list of values from a formula, putting these into a guage and summing them. Fine. Now I need to bring a set of four formulae together, doing slightly different things, each with a list of values, as before, to sum in a guage. But I need to add those formula results together, like a SQL UNION, then pass to the guage to sum up.

Not sure if I can 'add' the four formulae like this:

{x1}+{x2}+{x3}+{x4}

or should I sum({x1}) etc then put into the guage? Doesn't seem to work. No results on guage..