is there a way to work around it

You can definitely have multiple formula columns. To get their values just use the column ID like

result.getValue(result.columns[1]);

Hello Jen, can you get the values in a map/reduce script? Thank you

I don’t know, I’ve never done M/R