Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Equation Formula within Documentation referencing table data.

Answered
Request Demo

I want to be able to create an equation within our documentation that will calculate % change or PQ Growth referencing data found in an existing table. Is this something that's possible?

0

Comments

1 comment

Date Votes
  • Liz Walters

    Hi Chuck,

    Apologies about the delayed response! I must have missed this post a couple weeks ago. I think an option here could be to add a column to your table that calculates the percent change and then link that value in your documentation. If you would wish for this column not to show, it could be hidden once everything is linked. If you'd like to not add columns to the table, the values you need could always be linked to a sheet in a spreadsheet. Here, the percent change could be calculated before being linked to your documentation. Once the linking is complete, the Formats menu within the right-hand side Properties panel will be helpful for formatting the percent change for how you would like it to appear in the text. 

    Something that could also be beneficial, depending on your context, could be to link the word "increase" or "decrease" into your text based on the percent change value (image below).

    Thanks for your patience and I hope this helps! Let us know if you have any questions. 

    Cheers!

    0

Please sign in to leave a comment.