Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 17 Feb 2020 03:32:18 +0100Does Firebird 3.0's Window Function work in LO Base 6.4?https://ask.libreoffice.org/en/question/229737/does-firebird-30s-window-function-work-in-lo-base-64/Does Firebird 3.0's Window Function work in LO Base 6.4?
I have this query written in SQL:
SELECT "Date", "Qty", SUM( "Qty" ) OVER (Order by "Date" ) as "Daily Qty" FROM "Inventori"
Somehow, the command
Sum ("Qty") Over (Order by "Date")
is automatically changed by LO Base with
Sum ("Qty") Over ()
I have also tried to put the command on the normal query design mode, but the same thing happens. Does anybody have an Idea what went wrong?
Thank you.LO_FansMon, 17 Feb 2020 03:32:18 +0100https://ask.libreoffice.org/en/question/229737/cCalc How do I match name and count all cells with corresponding namehttps://ask.libreoffice.org/en/question/204525/ccalc-how-do-i-match-name-and-count-all-cells-with-corresponding-name/ Please see attachment
Trying to match names and then count numerical value for each name for cumulative total
example: column A, Row 2: name "A",
How do I match A2 name "A", to column AN, then add up all the numbers in column AM that match A2 name "A" and display in B2, I have added all the correct data in DA:D9, so the user is able to verify formula : : : ; .. .. [C:\fakepath\LO Matching trying to find accumulative count 08-13-2019.ods](/upfiles/15657125013793182.ods).
Thank you in advanceJG101Tue, 13 Aug 2019 18:09:24 +0200https://ask.libreoffice.org/en/question/204525/How do I create 12 month rolling total?https://ask.libreoffice.org/en/question/151310/how-do-i-create-12-month-rolling-total/ I am self-employed and want to stay under the VAT threshold so I need to keep an eye on my 12 month rolling total of earnings. I have a spreadsheet set up with 'month' in column A, 'earnings' in column B and I'd like column C to be rolling total for the previous 12 moths but I cannot for the life of me find a formula that allows me to see a total for the 12 months in any given month. Can anyone help please?mcgulliverWed, 04 Apr 2018 12:56:09 +0200https://ask.libreoffice.org/en/question/151310/Running total/cumulative sum of time?https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/Attached is an example document to help elucidate my question:
[C:\fakepath\Running total:cumulative sum of time example.ods](/upfiles/14950217499189278.ods)
In this document I want to use a formula to make a running total of the time logged. However, I don't want to convert the hours into minutes; I would like the figures to remain HH/MM/SS.
Obviously when the minutes reach 60, they should be converted into an hour, then reset, and when the seconds reach 60, they should be converted into a minute, then reset.
I would prefer that this could be done with the hours, minutes and seconds divided into 3 cells as shown, but if not possible, then placing all within the same cell would be acceptable.
How can I achieve this?
Cheers.
**-EDIT-** I have received an answer from **JohnSUN** that works.
I am leaving this thread open a little longer for the purpose of further discussion, but I am satisfied with this solution.
Will also take a look at some of the other answers when I get more time, thanks to all who have contributed.
***Here is the updated document, with the problem solved using JohnSUN's directions***:
[C:\fakepath\Running total; cumulative sum of time example UPDATED W: JOHNSUN'S ANSWER.ods](/upfiles/14950216461515751.ods)appreciatethehelpSat, 13 May 2017 18:08:12 +0200https://ask.libreoffice.org/en/question/95056/BASE - Column in query as cumulative valuehttps://ask.libreoffice.org/en/question/74094/base-column-in-query-as-cumulative-value/ I am lacking in SQL programming knowledge and would like to know how to generate a query which adds up the values of the previous rows. For example the first column would be something like grade school levels from 1st grade to 6th grade. The second column is number of students enrolled in that grade. These two columns are in a table. The third column which is the one I'm having trouble with is how many students in 1st grade, followed in the next row by how many students enrolled in 1st and 2nd grade, the third row adds all students from 1st to 3rd grade, etc. I want to generate a query that has all three of these columns. Any help will be appreciated. Alb58Wed, 27 Jul 2016 20:01:57 +0200https://ask.libreoffice.org/en/question/74094/Exclude cells from cumulative sumhttps://ask.libreoffice.org/en/question/31490/exclude-cells-from-cumulative-sum/Hi Libreoffice users,
This is a simple version of my spreadsheet in Libreoffice Calc : http://i.imgur.com/bgOTpWf.png
The C column starts with the formula =SUM($B$1:$B1) and the second one is =SUM($B$1:$B2) and so on, to calculate the cumulative sum of row B. Now I would like to automatically exclude the total cells from row C. (Because my own spreadsheet is really long)
Thanks in advance!
Version:
LibreOffice 3.5.4.2
Build ID: 350m1(Build:2)
OS: Debian Wheezy
LOUWed, 19 Mar 2014 15:36:17 +0100https://ask.libreoffice.org/en/question/31490/How do you draw a cumulative frequency graph in Calc? I have four pieces of data that need to be put into a cf graph...https://ask.libreoffice.org/en/question/7099/how-do-you-draw-a-cumulative-frequency-graph-in-calc-i-have-four-pieces-of-data-that-need-to-be-put-into-a-cf-graph/Cumulative Frequency GraphPanoli12Tue, 23 Oct 2012 22:16:48 +0200https://ask.libreoffice.org/en/question/7099/