How do I out formula expressions to an output file? For audit purposes

[JamesBarzda]

Hi,

I need to document how I've transformed a data set for audit purposes. What's the best way to copy  the details within a formula tool to an output file e.g. a tab in a worksheet called 'Formula logic'?

I've had a look around the portal and couldn't find a suitable resolution (e.g. I've seen people using screenshots but this isn't conducive of automation) 

Thanks in advance

JB

[Luke_C]

Hi @JamesBarzda 

Have you tried the field info tool? 

[JamesBarzda]

Hi,

I have but, as you can see below, I'm using one formula tool to calculate two columns based on a value within those columns e.g. if invoice number contains 'x' then minus 100 from 'Purchases Net GBP'. As we've got more than one manual adjustment, I've added a formula (Within one tool) to like the below. When I use the field info tool, it only displays the first formula for each column (shown in the second screen shot)

[avanbrunt]

I am having this same issue.  I am editing a field twice within one formula tool and the field info tool is only showing me the 2nd formula.  I need to output all formulas within the formula tool.  Has anyone figured out how to do this?