Stack Overflow
Stack Overflow

Questions tagged [calculated-field]

A calculated field (or calculated column) is a temporary (virtual) column which is generated by a query and contains the result of a calculation (i.e.: a price with VAT).
It only exists in the result set generated by the query.

728 questions
-1
votes
1 answer

Calculated fields in table

I'm trying to create a calculated field (Cost) in a database table for values entered by the user for example price and quantity like in the example below : Cost = Price * Quantity I searched but I couldn't find a clear way how to it.
Ferhat Boutaleb
  • 27
  • 1
  • 7
-1
votes
1 answer

Two Subqueries and a Calculated Field

I'm developing a very large query to retrieve data from an Army Reserve data warehouse. The purpose of the query is to populate an Access database table that is then used for forms and reports within my organization. Due to the extensive number of…
spacetanker
  • 119
  • 2
  • 15
-1
votes
1 answer

Reading an Access calculated field from Java on any OS (not just Windows)

How can I read calculated fields with UCanAccess or Jackcess (or any Java library that also works on Linux)? I don't care if I can't get the result straightaway, I'll settle for just getting only the function if need be. For simplicity, we'll…
user3037710
  • 11
  • 3
-1
votes
1 answer

Generate Summary report from logs : Peform additions on output of a command ( using AWK / SED or any other way) and formatting output

I am processing several files at a time.Each of which has summary stats . At the end of the process I want to create a summary file that will add up all the stats . I already know how to dig out the stats from the log files. But I want to be able to…
user1874594
  • 2,277
  • 1
  • 25
  • 49
-1
votes
1 answer

Bash Shell script to calculate an address in a subnet

This is a difficult one to extrapolate what I need, so bear with me. Let's say we have this subnet 10.4.x.0/28 which iterates itself across multiple subnets that look the same, i.e 10.4.0.0/28 10.4.0.16/28 10.4.0.32/28 etc... and we have a single…
dobbs
  • 1,089
  • 6
  • 22
  • 45
-1
votes
1 answer

php calculating total values inside specific array insteead of entire array

I have got an array that looks like: $costs = Array ( [0] => Array ( [amount_set] => 27.99 [amount_cost] => 17 [amount_markup] => 3.6 ) ) Array ( [0] => Array ( …
Yeak
  • 2,470
  • 9
  • 45
  • 71
-1
votes
2 answers

Unable to understand the SQL code

I am finding it difficult to understand the code below. Can you give me a logical flow of how the code works ? The question - suppose you want to display the total number of orders placed by every customer in your Customers table. Orders are stored…
YourDataInsecure
  • 23
  • 1
  • 3
-2
votes
1 answer

Sub Total on Google Sheet Pivot Table Shows the Wrong Sum

So, I made a pivot table with calculated formula in google sheets but somehow, the subtotal for each client was shown wrong the code for Total Income I've been using is this…
sadil
  • 19
  • 5
-2
votes
3 answers

JavaScript : How to get selected dropdown value?

I'm using code from w3schools & attempting to modify it so that the script will multiply by a different valNum based on the value selected from the drop down list. So if All Purpose Flour is selected the Output = Input multiplied by 4.409245; for…
NewtoJava
  • 1
  • 5
-2
votes
1 answer

Date Field Calculated Value last Day of last Month

I want to display always the last day of the previous month. So for example, right now it should display: 28.2.2021 Thanks in Advance!
Oliver Eckerstorfer
  • 1
-2
votes
1 answer

JQUERY why this field doesn´t change?

i reused the code from every calculation in there but nothing. seems like the field that is listening never change.
thnks for ur time
juan francisco quiñones romero
  • 38
  • 7
-2
votes
1 answer

excel pivot table - query based on mulitple columns value

I have a pivot table in excel that has an attribute say animals that holds 3 values (dogs, cats, birds) and the rows represent persons. |dogs|cats|birds| ---------------------- John| 0| 1| 1| Jack| 1| 1| 1| Jim | 0| 0| …
Mike W
  • 391
  • 4
  • 14
-2
votes
1 answer

Editing formula within multiple calculated fields concurrently

I have a pivot table with monthly run-rate forecast. e.g. on the 5th of Jan it would be [number]/5 *31 I change it every week so 5th/ 12th/19th etc. Only problem is I have lots of fields like this and lots of tables and lots of sheets. Is there any…
Tom Brooks
  • 1
-2
votes
1 answer

DOMPDF Calculation

PHP Page I have not understand what I have to do on this to show the net value. It doesn't show me any value. What should I do please help me.PDF File Here is the table code. I can't see the shipping charge net value in table footer.
Zenith Jhony
  • 1
  • 3
-2
votes
1 answer

Excel - running % of running total in pivot table

I have a table like: periodo quintil pos 201611 1 10 201611 2 20 201611 3 30 201611 4 40 201611 5 50 201612 1 9 201612 2 19 201612 3 29 201612 4 39 201612 5 49 I need to create a pivot table like: periodo quintil…
GabyLP
  • 3,649
  • 7
  • 45
  • 66
1 2 3
…
48
49