I am trying to create a local sum type inside of a function and then return said sum type without it being declared in main. Is this possible? I don't...

I have joined 2 databases, what i want is to get the total value/sum of these 2 multiplied column: Example on the database: Price Quantity 100 ...

I have two dataframes that look like the following library(dplyr) State = c('AK','AL','AR','AZ') Perc = c(0.0023, 0.0034, 0.0043, 0.065) df1 .frame(...

Like taking the value from the first row 60, then add it to the new value from the next row and so on, like the example of the below table. field ...

If I want to write a function summing two std::array, I would do something like: templateclass T, std::size_t N> auto sum(const std::arrayT, N>& a, co...

I have two tables in mysql : Orders (id, orderName) Order_item (id, partname, price, order_id) Order_id in order item is foreign key to Order table. H...

I have two Data Frames df and df1, based on the date range from df i want to sum the Distance column in df1 from io import StringIO data = """IGN,Ex...

From the below table I need to get the sum of unique customer coverage by month and age band: cust_id cmpgn_mth age_band coverage 1 202309 18-...

I'm creating a hotel booking tool for our desk/reception using PostgreSQL 16. To answer booking requests, I need both the total price and the associa...

I'm creating a hotel booking tool for our desk/reception using PostgreSQL 16. To answer booking requests, I need both the total price and the associa...

I am trying to add a row to the bottom of a grouped by data frame in Pandas, using following code import pandas as pd import matplotlib.pyplot as plt ...

I'm creating a hotel booking tool for our desk/reception. My current SELECT doesn't compute the "final" sum()/CASE, meaning that as long as there are ...

I need help getting a desired result returned. example Table1. IDNUMBER Amount V11652 1500 V11652 3000 V11652 4500 V11652 6000 V11643 ...

This works well and returns 249999500000: sum([x for x in range(1_000_000) if x%2==0]) This is slower but still returns 24999995000000: sum([x for x i...

Hi Guys i have this expressions where i sum sales based on multiple conditions =iif(Fields!ContName.Value="Africa") and iif(Fields!Country.Value="...

Let's say I have a number for example 12345. I want to calculate the sum each of all possible combinations for this number without changing the order ...

There are tables transactions and currencyRate: fiddle I am displaying transactions of client (sender_name) with total amount sent money more than (am...

This is an extension to this post. My dataframe is: import pandas as pd df = pd.DataFrame( { 'a': [ 'a', 'a', 'a', 'a', 'a', ...

I need to count all possible combinations of numbers to reach the given sum. They should be non decreasing(every next number should be greater or equa...

Assume there is a list[int] like this: [0, 2, 3, 3, 0, 9] I want to convert it to list[float] with a sum of 1 and keep the relations between the value...

I have a dataframe with a column "dname". It contains many rows of 2LD domain names. i.e. 123ask example92 what3ver ... I want to find the number of d...

Using SQL Server Management Studio v19.1. I need help. I have worked hours to try various joins and aggregations to get the result, but I cannot get i...

I have a table. When I am using formula: =FILTER(A1:C7,B1:B7="red",) what I am getting is: What I would like to get however is: Any ideas how to do...

in Excel I have a few cells containing numbers sperated bij a dash, like: I use a formula like =TRIM(TEKSTBEFORE(G30:G40;"/";1)) ...

I use OrderingFilter, i have pizza model connect to pizzaprice model by many to many field, when i ordering by desc or asc i get not the result expect...