Export formula iso value

Is it possible to add a feature to export formula and not only thr value?


I had almost the same wish, and found a workaround.

1 - a Rule transformation calculated different formulas (‘It’s an expression’) based on given criteria
2 - I copied the rule transformation, gave the output column a different name, and changed all results to ‘It’s a text or number’

This worked for me.
Instead of showing the actual calculations in the second rule transformation, I put a more descriptive text to show end users how result had been calculated.

1 Like


I still need the formulae in Excel as users will make change to spreadsheet and new values needs to be calculated
I am now investigating how to get formulae back in - did not want to go VBA route.