Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 30 Oct 2020 21:40:26 +0100Percent calculation in a Writer tablehttps://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/ I have a Writer table and there is a total sum in each cell at the bottom of two columns. I want a percentage, in another cell, of the first summed cell over the second summed cell. I saw there was a percent calculation option when I click on F2, so in the formula bar I have = phd and I assumed I would just end the equation like this
`= phd <D28> / <E28>`
but I get `** Expression is faulty **`. I have tried some other variations but not successful.
I know that I can enter `= <D28> / <E28>` in the formula bar and format it as percentage but I would like to find out how to use the included function and, by extension, the other functions offered. Nearly all the documentation I have found just shows Sum function as an example, although there was a paragraph in Help about using pipes `|` in Mean function.
Maybe I'm wrong and **percent** is for percentile function? Does anyone know of any complete documentation on the functions?Fri, 30 Oct 2020 06:30:31 +0100https://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/Answer by PKG for <p>I have a Writer table and there is a total sum in each cell at the bottom of two columns. I want a percentage, in another cell, of the first summed cell over the second summed cell. I saw there was a percent calculation option when I click on F2, so in the formula bar I have = phd and I assumed I would just end the equation like this </p>
<p><code>= phd <D28> / <E28></code></p>
<p>but I get <code>** Expression is faulty **</code>. I have tried some other variations but not successful.</p>
<p>I know that I can enter <code>= <D28> / <E28></code> in the formula bar and format it as percentage but I would like to find out how to use the included function and, by extension, the other functions offered. Nearly all the documentation I have found just shows Sum function as an example, although there was a paragraph in Help about using pipes <code>|</code> in Mean function.</p>
<p>Maybe I'm wrong and <strong>percent</strong> is for percentile function? Does anyone know of any complete documentation on the functions?</p>
https://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/?answer=274112#post-id-274112I hope that will help you.
[Formula](https://help.libreoffice.org/7.0/en-US/text/swriter/02/14020000.html)Fri, 30 Oct 2020 09:30:45 +0100https://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/?answer=274112#post-id-274112Comment by Earnest Al for <p>I hope that will help you.</p>
<p><a href="https://help.libreoffice.org/7.0/en-US/text/swriter/02/14020000.html">Formula</a></p>
https://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/?comment=274231#post-id-274231Thanks for path but as I was using my production computer which runs LO 6.4.6 the help didn't seem to include that page. Internet search engine didn't deliver either; I obviously didn't ask the right questions. Cheers, AlFri, 30 Oct 2020 21:40:26 +0100https://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/?comment=274231#post-id-274231Comment by PKG for <p>I hope that will help you.</p>
<p><a href="https://help.libreoffice.org/7.0/en-US/text/swriter/02/14020000.html">Formula</a></p>
https://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/?comment=274139#post-id-274139**I am trying to describe the path.**
**Open the help** → choose: Module Writer
1. **Working With LibreOffice Writer** → LibreOffice Writer Features (link)
2. **Calculations** → calculation function (link)
3. **Formula (link)**Fri, 30 Oct 2020 11:50:48 +0100https://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/?comment=274139#post-id-274139Comment by Earnest Al for <p>I hope that will help you.</p>
<p><a href="https://help.libreoffice.org/7.0/en-US/text/swriter/02/14020000.html">Formula</a></p>
https://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/?comment=274126#post-id-274126Thanks, I've bookmarked the page as I can't find it again by search. Odd it wasn't linked from Table Calculation which has many links but not very useful.
My related question is does anyone know what *percent* in this context actually means? Is it as implied in the Help, the not very useful `a + b/100` (example given `10 + 15 PHD displays 10.15`), or is phd just ignored as in `=<A1>+<B1>phd displays 25` where A1 is 10 and B1 is 15?Fri, 30 Oct 2020 11:05:43 +0100https://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/?comment=274126#post-id-274126Answer by ajlittoz for <p>I have a Writer table and there is a total sum in each cell at the bottom of two columns. I want a percentage, in another cell, of the first summed cell over the second summed cell. I saw there was a percent calculation option when I click on F2, so in the formula bar I have = phd and I assumed I would just end the equation like this </p>
<p><code>= phd <D28> / <E28></code></p>
<p>but I get <code>** Expression is faulty **</code>. I have tried some other variations but not successful.</p>
<p>I know that I can enter <code>= <D28> / <E28></code> in the formula bar and format it as percentage but I would like to find out how to use the included function and, by extension, the other functions offered. Nearly all the documentation I have found just shows Sum function as an example, although there was a paragraph in Help about using pipes <code>|</code> in Mean function.</p>
<p>Maybe I'm wrong and <strong>percent</strong> is for percentile function? Does anyone know of any complete documentation on the functions?</p>
https://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/?answer=274114#post-id-274114It is quite complicated to find the *Formula* page in built-in help.
From reading it, I understand that formula syntax is quite "original" in Writer. Parentheses are not always necessary in "functions". I consider then that some "functions" in the submenu are rather operators.
This seems to be the case for `phd` as a **suffix** operator. It probably divides by 100 the preceding operand <del>but I don't succeed in getting a predictable result without "expression is faulty"</del>.
**EDIT**: from experiment, it looks like `phd` only accepts a literal number as its left operand; a cell reference like `<A1>` causes the "expression is faulty" error.
The vertical bar `|` is the **list** operator to pass a list to prefix operators like `MIN`, `SUM` or `MEAN`.
As it has been frequently stated, tables in Writer are meant for text in tabular form. A courtesy very limited computation capability is offered but it is generally preferable to insert a Calc table as soon as the needed computation goes beyond simple addition.
The only interest in Writer table "functions" is the possibility to retrieve document statistics like `WORD` for the number of words but this can also be retrieved in a more versatile way with **fields**.
*To show the community your question has been answered, click the ✓ next to the correct answer, and "upvote" by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!*
*In case you need clarification, **edit** your question (not an answer which is reserved for solutions) or **comment** the relevant answer.*Fri, 30 Oct 2020 09:46:03 +0100https://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/?answer=274114#post-id-274114Comment by Earnest Al for <p>It is quite complicated to find the <em>Formula</em> page in built-in help.</p>
<p>From reading it, I understand that formula syntax is quite "original" in Writer. Parentheses are not always necessary in "functions". I consider then that some "functions" in the submenu are rather operators.</p>
<p>This seems to be the case for <code>phd</code> as a <strong>suffix</strong> operator. It probably divides by 100 the preceding operand <del>but I don't succeed in getting a predictable result without "expression is faulty"</del>.</p>
<p><strong>EDIT</strong>: from experiment, it looks like <code>phd</code> only accepts a literal number as its left operand; a cell reference like <code><A1></code> causes the "expression is faulty" error.</p>
<p>The vertical bar <code>|</code> is the <strong>list</strong> operator to pass a list to prefix operators like <code>MIN</code>, <code>SUM</code> or <code>MEAN</code>.</p>
<p>As it has been frequently stated, tables in Writer are meant for text in tabular form. A courtesy very limited computation capability is offered but it is generally preferable to insert a Calc table as soon as the needed computation goes beyond simple addition.</p>
<p>The only interest in Writer table "functions" is the possibility to retrieve document statistics like <code>WORD</code> for the number of words but this can also be retrieved in a more versatile way with <strong>fields</strong>.</p>
<p><em>To show the community your question has been answered, click the ✓ next to the correct answer, and "upvote" by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!</em></p>
<p><em>In case you need clarification, <strong>edit</strong> your question (not an answer which is reserved for solutions) or <strong>comment</strong> the relevant answer.</em></p>
https://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/?comment=274129#post-id-274129Thanks. That seems to correlate with my experiments over the last hour using Help found by PKG.
My table is text heavy with formatting that is not so easy to replicate in Calc. I want to place the table in a template so would like it to be correct from the beginning. A couple of one-off Sums and a percentage were all the calculations that were necessary but I got side-tracked by the percent issue. Another character defect I suppose, I tend to get a bit obsessed with problems until some sort of resolution appears.Fri, 30 Oct 2020 11:20:10 +0100https://ask.libreoffice.org/en/question/274102/percent-calculation-in-a-writer-table/?comment=274129#post-id-274129