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
4
votes
2 answers

In an IIf function in Access, how do I assign null values?

I'm creating a calculated field (Field3) in a query in MS Access. In this example, Field2 contains both numeric and character values. I want Field3 to contain only numeric values from Field2 and to convert all character values to Null values so that…
LM6
  • 149
  • 3
  • 11
4
votes
1 answer

MS Dynamics CRM online calculated field error

I have a custom entity, Duration calculation, which is used to calculate duration of Sales stage on Opportunity. In that entity, I have a calculated field which calculates duration between the stage start time and endtime (image attached). When I…
Mahmood
  • 177
  • 2
  • 10
4
votes
1 answer

Excel: Pivot Table - Percentage of one value from another

My pivot table has 3 columns: Row label (expand/collapse items in each row) Count of Case Count of Assigned My DATA sheet has 2 sets of data: "Case" (line item for every bug, feature, etc.) "Assigned" (name of the person assigned to the case) On…
Knaledge
  • 43
  • 1
  • 1
  • 4
4
votes
1 answer

How do I get the Average number of days between multiple dates in Tableau

I'm using Tableau and I have a field called Sales_Order_Date. I need to get the AVERAGE number of days between each sales order. Example: I have 3 orders 01/01/2014 20/01/2014 30/01/2014 The number of days between order 1 and order 2 = 19 days The…
StefanHanotin
  • 191
  • 5
  • 17
4
votes
3 answers

Delphi - Change field to calculated field at runtime. Is this a good practice?

As in the question's title, I argue with a colleague about how calculated fields should be used. From my knowledge, calculated fields are created at runtime as in the François's answer on the question Adding a calculated field to a Query at run…
RBA
  • 12,337
  • 16
  • 79
  • 126
3
votes
1 answer

Google Data Studio convert metric to dimension not working

I have imported my GA4 data into Google Data Studio and am trying to see how many giftcards have been sold by their value. The item revenue metric in GA4 is equal to the giftcard value (i.e. revenue = $200 therefore $200 giftcard was sold). I want…
DrPaulVella
  • 391
  • 8
  • 22
3
votes
2 answers

how to populate mysql column value based on a formula?

I have created a mysql table with the following columns... item_price, discount, delivery_charge, grand_total The value of item_price, discount, and delivery_charge all vary depending on the item under consideration, and these would be filled into…
arun nair
  • 3,643
  • 14
  • 41
  • 49
3
votes
2 answers

HTML and Javascript Form not calculating on submit

I'm new to coding. I'm having an issue with a form not returning a calculated value and I'm not sure what I did wrong. When I press submit nothing happens. I don't see any linting errors. A brief red pops up in the dev tools on chrome but not long…
Corvidae
  • 31
  • 3
3
votes
2 answers

(Quicksight) How to Sum Values only from Unique Fields

My data set has a {Invoice No} field that I want to sum the cost of. All invoice numbers are unique and have one cost value. However, because there are multiple {Part No} fields in each {Invoice No}, Quicksight multiplies this one cost by however…
Big Chungus
  • 185
  • 1
  • 3
  • 13
3
votes
0 answers

Calculate coefficient of variation in pivot table (Excel)?

Is there any way (besides power pivot or fields calculated outside the pivot) to calculate the coefficient of variation (standard deviation/average) in a pivot table? When I create a calculated field with =STDEV('Field')/AVERAGE('Field') it doesn't…
matzewe
  • 41
  • 2
3
votes
1 answer

Power BI - Using of filters in calculate function

Please refer below to the sample data i used: ID Name Status Dept. 1 Austin Pending MES 2 Roy Devilered DHA 3 Steven Terminated DHA 4 Peter Pending MES 5 Sanjay Pending MES 6 …
MJoy
  • 1,349
  • 2
  • 9
  • 23
3
votes
1 answer

Math calculation in Watson Conversation response

I am pretty starting some flows and testing, maybe this is a fool question, sorry. I have a flow asking for some inputs (amount, and currency). I want the conversation bot to answer the total (amount * currency). I did several researches, but…
Alexandre Marini
  • 230
  • 1
  • 8
3
votes
0 answers

Google Data Studio: adds a prefix to the column and throws a error

I am trying to use Median function in Google Data studio to create a calculated field but when it runs and it adds "t0." before the columns name and a error pops up There`s a query error. Field 't0.WordsFound' not found; did you mean…
Antonio Teixeira
  • 31
  • 5
3
votes
2 answers

Filtering by a calculated measure involving multiple fields in Qlik Sense

I am trying to use a calculated measure as a way to filter my data, but it's looking more difficult than expected. Let me explain through an example. I have data of the following type, with two dimensions - one is a unique ID, the other a category -…
etste
  • 55
  • 1
  • 2
  • 7
3
votes
1 answer

SQL Calculations based by field type and group by the type

Database includes FamID, TicketType and Amt I want to get a calculation for total amount for each tickettype for each family and sort by family high to low based on total for all tickettypes. Database values are: FamID TicketType …
Kathy Kaiser Minnick
  • 55
  • 6
1
2
3
…
48 49