The total of part of a series of numbers
Questions tagged [subtotal]
398 questions
-1
votes
2 answers
Place Subtotal value in all cells in group
I have a requirement where i need to enter the value of a SubTotal in each row for the corresponding group. Below is a snapshot of the subtotals in in Column Q and this value manualy entered by me in Column M. I'm happy to create a Macro to do this…
Prospidnick
- 133
- 1
- 10
-1
votes
1 answer
Use of subtotal by ignoring the column header
I am trying to use subtotal to calculate the totals for a set of columns. The position of the rows can change for different scenarios. Since the position of the rows are fixed, I am unable to set a range. At present, the subtoal always includes the…
Shilpa
- 98
- 3
- 19
-1
votes
2 answers
javascript calculate 10% discount on sub total
How to implement calculating 10% discount base on sub total in js?.
Here is my code.
function calculateGrandTotal() {
var grandTotal = 0;
$('table tbody tr td:nth-child(4) input').each(function (index) {
…
Juan dela Cruz
- 9
- 2
-1
votes
2 answers
sum of $row based on specific time field rather than just total
This code works just fine to display a list of reservations for a given day and sums the guest and table counts just fine for the entire day. Sums all reservations returned.
What I am trying to do or figure out is a way to get totals based on…
ToddG
- 13
- 4
-1
votes
1 answer
Calculating totalCost
Ok below is my code for a class I am taking... I need to know how to properly code the totalCost for this product and I can not for the life of me figure out how to properly do this. The price per product is $1 and I need to calculate a 7% sales tax…
-1
votes
3 answers
Conditional Summation of Numerical Objects in a list
I have a dataset that I am outputting to a list in the following way:
using System;
using System.Collections.Generic;
using System.IO;
using System.Text;
using System.Text.RegularExpressions;
using System.Linq;
using System;
using…
Cylen
- 119
- 3
- 13
-1
votes
2 answers
Grouping and sub Total in data table C# ASP.NET
I have a DATA Table :
COLUMN: City Deposittype DepositAmount
ROWS : city1 new 100
city1 new 200
city2 old …
Thejo Arjun
- 1
- 4
-1
votes
1 answer
Sub total at the end of Query result Table
I'm trying get the subtotal at the end of the table for Accepted, cancelled, noShow and flagged...I try grouping but its throw an error. Is there any other or easy way to do it?
Select * From (
SELECT
c.ComID, ISNULL(c.Client,'-') AS Driver_Name,…
DBA_assis
- 25
- 8
-2
votes
1 answer
Subtotal with countifs in different columns
From given table i want to count number of text "Yes" from Result column where numeric value is 25 or 35 from number column. I want to use subtotal here as i have to filer data on groups.
Rajiv
- 29
- 2
-2
votes
1 answer
Update SUMIF formula to support filtered data
I have a table of times logged per date (and a stack of other info not relevant here)
logTable
Date - Project - other stuff - Hours
1 Jul - X - ... - 3 hrs
1 Jul - Y - ... - 2 hrs
2 Jul - X - ... - 4 hrs
etc.
I then have a formula which calculates…
Ned Martin
- 494
- 6
- 12
-2
votes
2 answers
PHP total order
I have a site that displays items with radio buttons. I want to make the PHP code display the total for the user when they submit the code.
Below is the code I have so far along with the prices for each item that would be in the store.
zmw123
- 7
- 2
-2
votes
3 answers
SQL: How to find top customers that pay 80% of revenue?
Let's say I have a table TRANSACTIONS:
desc customer_transactions;
+------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra …
ipolevoy
- 5,432
- 2
- 31
- 46
-2
votes
1 answer
Subtotal and total count in table Javascript
I will need your support to count subtotal and total in html table (without buttons).
Formulas of table:
Subtotal: 1st column * 2nd column (inputs)
Total: Sum of subtotals
