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
-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?
-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
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…
-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…
-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?
1 2 3
48
49