Stack Overflow
Stack Overflow

Questions tagged [subtotal]

The total of part of a series of numbers

398 questions
4
votes
1 answer

Minimizing differences in specified number of subtotal groups

I have data like this: A B C D Book1 1 49 2 37 3 31 4 46 163 5 35 6 47 7 40 8 38 160 9 45 10 25 11 38 12 …
user438
  • 141
  • 3
4
votes
1 answer

How to get the tax amount in the thank you page in magento

I am trying to get the tax amount to deduct from the total amount or just get the bare subtotal amount so i can put it in an affiliate link but I am not being able to get the tax amount or bare subtotal in the last thank you page after the customer…
jarus
  • 1,853
  • 11
  • 44
  • 76
3
votes
1 answer

Magento - How to get the subtotal for a single product in cart?

I want to display the total price for each product (by id) in the cart. qty | single price | total 2 | $ 2.00 | $ 4.00 <-- that's what i need 3 | $ 5.00 | $ 15.00 | Subtotals: | $ 19.00 <-- that's what i get with the code…
ThreeCheeseHigh
  • 1,429
  • 5
  • 22
  • 40
3
votes
3 answers

Subtotal depending on multiple columns in r

Here is a test table: df <- read.table(text=" str1 str2 name t y x a yes bas 23 323 21 b no aasd 23 54 33 a no asd 2 43 23 b yes hggf 43 123 55 …
Maksym Moroz
  • 306
  • 2
  • 14
3
votes
3 answers

How to add totals row to excel power query?

I have produced a table like the one below by using 'group' function in excel power query score 1 score 2 score 3 A 6 25 50 B 8 30 20 C 15 15 30 D 20 0 10 I want to add a totals row (equivalent to "show totals for column" in a…
user11345588
  • 69
  • 1
  • 2
  • 8
3
votes
1 answer

Rails - Subtotaling based on if statements

What it looks like currently


…
Jack Stovell
  • 33
  • 7
3
votes
2 answers

SQL monthly join and monthly total percentage

My head is smoking from (stupid) tries of using JOIN, WITH and GROUP BY to come up with a solution for my pretty common scenario - I just can't wrap my head around it. Let me throw the example at you right away: I have two tables (ColorCount and…
Dennis G
  • 21,405
  • 19
  • 96
  • 133
3
votes
1 answer

Forming SQL Query for Detail and Subtotals (MySQL)

I have a common SQL task but can't find a clear path to the solution. I have a table, downloads with the columns, download_date, image_file_id, credits. What I want at the end is the detail, plus a subtotal of credits for the day at the end of each…
Steve Ross
  • 4,134
  • 1
  • 28
  • 40
3
votes
3 answers

Linq syntax to find subtotal of grouped rows in a DataTable and update the DataTable

I have been scratching my head about this one... I have a table in memory, a DataTable structured like this: Input: ID | Invoice | Account | Payment | Subtotal ----------------------------------------------------------------- 0 | …
actinade
  • 55
  • 8
3
votes
3 answers

Stata: Generate sum / total by specific date ranges and save them as a new variable

I work with panel data which contain several companies (id) and cover the period from 1.1.2008 to 1.1.2013 (date, year). I want to generate new variable (sum1) which contains a sum of daily observation for var1 for each company and specific time…
In777
  • 171
  • 1
  • 4
  • 15
3
votes
2 answers

Oracle Sql: How to add multi sub total in sql?

I want query multi sub total in query sql. How query multi sub total. please help me. SQL CODE: SELECT MB.COUNTRY_CODE As C_CODE, MB.OPERATOR_NAME AS C_NAME, C.PMN_CODE AS OPER_NAME, (C.RANG_START / 1024) AS R_START, …
nettoon493
  • 17,733
  • 7
  • 30
  • 45
3
votes
1 answer

hide subtotal from cart magento

How to hide Unit Price and Subtotal from Magento cart ver. 1.7.0.2 Previously it worked at the following lines on /app/design/frontend/base/default/template/checkout/cart/item/default.phtml online number 104 , 106 ,196 , 198 and few changes in…
Muddassar Ahmad
  • 516
  • 4
  • 8
3
votes
2 answers

Need Excel SUBTOTAL to use sums from differing columns conditionally

I have a fairly simple Excel 2007 worksheet with three columns; a name (Column A), Value1 (Column B), and Value2 (Column C). This sheet will often be auto-filtered by the Name column. At the bottom of the 2nd column, I want to perform a conditional…
David W
  • 10,062
  • 34
  • 60
3
votes
2 answers

Subtotal Calculation in Matlab

I would like to take subtotal of table in matlab. If the values of two columns are equal, take the value and add if there is an entry. If we give an example, source matrix is as follows: A = [1 2 3; 1 2 2; 1 4 1; 2 2 1; 2 2 3]; The output would…
user1921722
  • 55
  • 4
2
votes
3 answers

Javascript calculate total

I have this code : http://jsfiddle.net/VAkLn/6/ When i add a table : http://jsfiddle.net/VAkLn/7/ this stop working. Why? Solved: I change This: price = self.next(".price"), To: price = $(".price"),
Geme
  • 354
  • 2
  • 3
  • 13
1
2
3
…
26 27
Month Month Total Written Verbal Probable 75% Probable 25%