Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 08 Jan 2019 22:43:40 +0100Calc Pivot Table Total Sum column ignoring data formathttps://ask.libreoffice.org/en/question/178675/calc-pivot-table-total-sum-column-ignoring-data-format/I have a pivot table source , that has a column for the amounts of purchased items. That column is formatted as currency. The field is called sum_amount. The pivot table recognizes the currency format of the source for sum_amount fields in the table, but the total_sum_amount on the far right column, the format is ignored. Has anyone else noted this? or is there something i'm missing when i am create a pivot table?
Here is the version of LO I use.
Version: 6.1.2.1 (x64)
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU threads: 4; OS: Windows 10.0; UI render: GL;
Locale: en-US (en_US); Calc: CLAdmFubarTue, 08 Jan 2019 22:43:40 +0100https://ask.libreoffice.org/en/question/178675/Calc: How to carry out a cumulative addition using iterationhttps://ask.libreoffice.org/en/question/154533/calc-how-to-carry-out-a-cumulative-addition-using-iteration/Found the above title to a question in FAQs.
The example is given in the screenshot below.
/Users/sights/Desktop/Screen Shot 2018-05-24 at 6.16.39 pm.jpg
This example doesn't work as I think there is an error in the formula in referencing the cell E7...
=IF(C5=0,0,E7+((C10-C13+C16)/2))
This formula is in cell E7, and it tries to add itself to the equation.
I think the cell reference should be C7, and when I add the same formula to my sheet, I get a cumulative addition, but a very erratic results.
The first calculation doubles the answer, as the FAQ explains, the next two or three calcs work fine, then the erratic behaviour starts and the cumulative result is all over the place.
Also, if I add the same number to the target cells, the formula does nothing - only if the numbers are different to what is already in the cell.
I have tried many variations of this formula without success. That said, I am a novice at spreadsheets, and my maths is only average, so my understanding of formula construction and syntax is limited.
Any help would be very appreciative.
An example of my sheets are below...
/Users/sights/Desktop/Sheet 1.jpg
/Users/sights/Desktop/Sheet 2.jpg
Sheet 1 adds a customer's order, while on sheet 2, column C is the running total, and where I want the cumulative addition.
I need to be able to keep an accurate total that can be updated once a week, using the Today() function in A2 on either sheet.
I am in desperate need of help, so all efforts would be gratefully appreciated.SightsThu, 10 May 2018 13:23:03 +0200https://ask.libreoffice.org/en/question/154533/How do I have the total amount from an Invoice Form update an invoice total column in an invoice table?https://ask.libreoffice.org/en/question/147595/how-do-i-have-the-total-amount-from-an-invoice-form-update-an-invoice-total-column-in-an-invoice-table/ I'm creating an invoice and inventory database for my first time. For the invoice database I have a customer, employee, invoice, invoice details, and products table. Relationship schema is set up and everything seems to be working. Where I'm confused is how to get the total from an invoice to update an invoice total column in the invoice table. Thank you kindly for any help.SpaceCadetMon, 26 Feb 2018 19:39:23 +0100https://ask.libreoffice.org/en/question/147595/What is the formula for adding up a column?https://ask.libreoffice.org/en/question/139728/what-is-the-formula-for-adding-up-a-column/ I have several columns on a spreadsheet and need to keep a running total - How do I do this?DanecosseSun, 03 Dec 2017 21:03:18 +0100https://ask.libreoffice.org/en/question/139728/How do I add totals above the bars on a stacked bar chart?https://ask.libreoffice.org/en/question/91912/how-do-i-add-totals-above-the-bars-on-a-stacked-bar-chart/I created a stacked bar chart and would like the display the total of all values for each stacked bar at the top of each bar.JazzCatSun, 02 Apr 2017 06:38:20 +0200https://ask.libreoffice.org/en/question/91912/help with grand totalhttps://ask.libreoffice.org/en/question/86519/help-with-grand-total/I am Still having an issue on a base report and not sure what I have wrong. I have a table for (simplicity here) of 3 fields. One is kit manufacturer, second one is name of kit , 3rd one is price
.
When I make the report I am trying to get the total of all kits. In the report footer I added a text box and when I go to the properties data tab I click function. When I do my data fields are empty so I can not click price. I was going to use the accumulation function to add all the prices. Any idea why my data fields in the function would be blank? I have a pretty good start to my first project in base however if I can not get a grand total I wont be able to use my information
Edit:
[C:\fakepath\Model Railroad .odb](/upfiles/1485824538396076.odb)
Not sure If I did this right but I tried to add the databsejlg759Tue, 31 Jan 2017 01:18:56 +0100https://ask.libreoffice.org/en/question/86519/Show total when selecting cells in Calc?https://ask.libreoffice.org/en/question/68114/show-total-when-selecting-cells-in-calc/Hello all,
I have a calc sheet with a couple of columns that hold different numbers.
I'm selecting an cell outside the filled columns and press the Sum button which gives me the possibility to select multiple cells on one column.
The question is if is there any functionality that I don't know so when I'm selecting the cells also to see the total, like an tooltip or in status bar, like an realtime total of the selected cells so far? If I hit enter the total will be shown in the cell, but until then I see just the SUM formula and the number of the row/columns.
This is helpful for me because I have to add certain rows and to have an total of certain value, which now I only see after I've hit enter on the Sum function.ScieriTue, 12 Apr 2016 17:11:35 +0200https://ask.libreoffice.org/en/question/68114/how to generate subtotals in a report?https://ask.libreoffice.org/en/question/39872/how-to-generate-subtotals-in-a-report/Using Report Assistant in Base.
Sorting/Grouping for Column Cost.
No Subtotals and Total for Column Amount.
How to make these Totals?
DickStompMon, 15 Sep 2014 17:28:42 +0200https://ask.libreoffice.org/en/question/39872/