Stack Overflow
Stack Overflow

Questions tagged [fiscal]

46 questions
7
votes
1 answer

python pandas: get fiscal quarter from fiscal year and month (for UK)

I have a dataframe with two useful columns 1) fiscal year, 2) date. I want to add a new column which shows the fiscal quarter. FYI - UK Financial year runs from 1 April to 31 March my data looks like: fiscal year date FY15/16 …
Boosted_d16
  • 13,340
  • 35
  • 98
  • 158
3
votes
0 answers

Get fiscal week of year from date using SQLite query

I have used the below the SQLite query to find week of year for Calendar(Jan-Dec). "SELECT STRFTIME('%W' ,[Orders].[OrderDate] ) AS [Grid_Column_0],SUM([Orders].[Freight]) AS [Grid_Column_1] FROM [Orders] AS [Orders] GROUP BY STRFTIME('%W'…
Kavitha M
  • 263
  • 1
  • 7
  • 23
3
votes
1 answer

MySQL - count by month (including missing records)

I have this SELECT: SELECT DATE_FORMAT(`created`, '%Y-%m') as byMonth, COUNT(*) AS Total FROM `qualitaet` WHERE `created` >= MAKEDATE(year(now()-interval 1 year),1) + interval 5 month AND `status`=1 GROUP BY YEAR(`created`),…
bernte
  • 1,184
  • 2
  • 19
  • 34
2
votes
2 answers

Connecting Fiscal printer with flutter app

I'm working on a kitchen app in flutter. So I need to connect different types of printers to get the KOT and customer prints. I've already connected EPSON thermal printers Starmonics TSP100III Bluetooth printers SUNMI printers But not able to…
Usama Kabir
  • 53
  • 5
1
vote
1 answer

Fiscal year and fiscal quarter

I have a table where I store order dates YYYY-MM_DD. How do I create fiscal year and fiscal quarter with the following requirements: Fiscal years: start date for Fiscal_Year_2000 is 1999-07-01 and ends on 2000-06-31 start date for Fiscal_year_2001…
user14496743
  • 35
  • 4
1
vote
1 answer

SQL Get Quarter over Quarter values

I'd Like to get QoQ from a dataset with Q3 and Q4 data that also has a report date column, each row should have a QoQ value for each fiscal month (represented by a report date), Q4 should compare against Q3 but my statement only seems to be…
Dan A
  • 13
  • 1
  • 6
1
vote
1 answer

How to calculate number of months in between 2 dates having custom financial calendar defined?

I've scenario where custom financial calendar is defined. Sometimes the month can be of 28 days or sometimes it can be of 35 days as well. The start of every month varies. (It can start from 10/15/20th) For referring which calendar date refers to…
AshwinK
  • 1,039
  • 1
  • 12
  • 31
1
vote
1 answer

Fiscal year in power bi

I want to create fiscal year from start-date 01-Jul-2015 to end-date 30-Jun-2017 i have this code now i modified this code according to the give fiscal year Cal = ADDCOLUMNS ( CALENDARAUTO ( 3 ), "MIndex", MONTH ( EDATE ( [Date], -3 ) ), …
rebma testio
  • 57
  • 2
  • 10
1
vote
2 answers

How to use Pandas within Python to create a Fiscal Year Column?

I have a code with python that cleans a .csv up before I append it to another data set. It is missing a couple columns so I have been trying to figure how to use Pandas to add the column and fill the rows. I currently have a column DiscoveredDate in…
Moldy Mushroom
  • 51
  • 2
  • 9
1
vote
0 answers

Chrome app, how to send commands to a Datecs DP05BT fiscal printer?

I'm trying to make a chrome app that can send commands to a Datecs DP05BT fiscal printer. I managed to establish a connection to the fiscal printer but I don't know how to use chrome.bluetooth.send to send a command (<44> for example) to the…
Sorin Ilie
  • 21
  • 3
1
vote
1 answer

Using SQL Server windowing function to get running total by fiscal year

I'm using SQL Server 2014. I have a Claims table containing totals of claims made per month in my system: +-----------+-------------+------------+ | Claim_ID | Claim_Date | Nett_Total | +-----------+-------------+------------+ | 1 | 31 Jan…
Frank Bailey
  • 185
  • 2
  • 17
1
vote
0 answers

How to handle more than 12 month per year

I am trying to analyze some german accounting data. I don't know if it's only a german thing but many companies in Germany have more than 12 month per fiscal year. In my case i have a column for year and for "month" where the range in this column is…
user1056212
1
vote
1 answer

MySQL - select as fiscal year

I have this SELECT: SELECT m.`maschine-name` AS byMaschine, q.`mname` AS byMName, SUM(YEAR(q.`created`) = YEAR(CURDATE())) AS total FROM qualitaet q INNER JOIN maschinen m ON m.maschine = q.maschine WHERE …
bernte
  • 1,184
  • 2
  • 19
  • 34
1
vote
1 answer

Munge tuples of yearly fiscal data with element date-labels into a time-series in Python Pandas

I am trying to convert SQL -> .csv data dump flat file into a time-series for each company. The crux for me is that the data is organized into yearly tuples of 4 quarters. The quarter-end dates are Fiscal quarters given in the first tuple of each…
Erik
  • 412
  • 1
  • 5
  • 11
0
votes
0 answers

How to create a YTD using fiscal year / financial year

Apologises if this question has already been raised but I'm struggling with my data model to create a rolling total / YTD sales using fiscal years. I know PowerBI/DAX is great using calendar Jan-Dec dates but how do you amend this if your financial…
Hashim
  • 1
1
2 3 4