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.
Questions tagged [calculated-field]
728 questions
-2
votes
1 answer
Calculate height based on clicks or a number
I'm working on something exactly like (Your reaction?) in Buzzfeed
I don't know how they making this chart height average percentage?

Eiad Ashraf
- 9
- 5
-2
votes
1 answer
Excel How to calculate SUM of specific condition
I want to calculate SUM in specific condition in online excel sheet
For example:
Oct James DONE 2
Oct Michel DONE 5
Oct James DONE 2
Oct James Pending 1
Now I want calculate hours of only James work with DONE status (Not Pending…

MMaggy
- 42
- 1
- 4
-3
votes
1 answer
How to write a calculated field in Tableau which counts the number of products whose price tags are missing (null) and whose price <> $99?
I tried to write it using ISNULL but I'm getting error.

Rahul Diggi
- 288
- 2
- 16
-3
votes
2 answers
CakePHP 2.0: How can i work with own functions
I work with CakePHP 2.0. I made a new function sort and had no problem, if I take the table fields. But if I want to calculate something and give the result (method: 'Participant.year'=>'calculateyear' ) in my sort method, I have no result on my…

newWpUser83
- 1
- 1
-4
votes
1 answer
can't understand calculate method
I have problem in calculate method
it should do like give me that total price like quantity*5
it should do like any number*5 like 1*5 =5 2*5 =10
but the problem here if I change the quantity to 2 it will give me the price 20 $
quantity 3 it…

Mostafa
- 1
- 1
-4
votes
2 answers
The Code Won't Execute all
I have the following code:
private void G1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
decimal quantity = 0, cost = 0;
decimal totalstock = 0, newtotalstock = 0;
if…

Serenade
- 50
- 1
- 11
-4
votes
1 answer
calculate values
In an order form, each row has 3 fields: quantity, price, total.
How do I create a function that on changing a number the subtotal is calculated and so is the total?
Can anyone suggest a way?

user1725969
- 3
- 2