Export formula iso value

Feature requests
1

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

Thanks

2

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.

image
image.png904×800 35.4 KB

1 Like
3

Thanks.

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.