FAQ Database Discussion Community


Calculated fields in table

database,delphi,delphi-7,calculated-field
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....

Event Driven Data Macro to Calculate Field in New Record - MS Access

vba,ms-access,calculated-field,ms-access-data-macro
In MS Access 2013 I have a table called [Serials] which consists of only 3 columns: [ID], [Hashed ID] and [Product Description]. [ID] is an Incremental Integer Autonumber, and the Primary Key. [Hashed ID] holds the result of a Hash Function applied to [ID]. Finally, [Product Description] holds user input...

Excel: Pivot Table - Percentage of one value from another

excel,pivot-table,calculated-field
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 the pivot table, how do...

Calculated field with value from another table in Microsoft Access

mysql,ms-access,ms-access-2013,calculated-field
I have a calculated field in a table that needs to take the value from another table but in the expression generator window it doesn't allow me to choose values from other tables. Then, I tried to create a form from the table, and put in the source control the...

creating a calculated field in excel pivot table based on an item in a column

excel,pivot-table,calculated-field
Normally calculated pivot table fields in excel (2010) you click: design tab > options and sets > calculated field and if you had three columns: name, sales, cost name | sales | cost josh 10 2 your calculated field might be: profit which would be: = sales - cost. However...

Simple Enquiry with Complex Answer - How do I Select RowA6-Row(last non-blank) for a simple formula

excel,excel-vba,cell,calculated-columns,calculated-field
I have many columns all labeled with many many values underneath, which can be words or numbers Here is the current equation =INDEX(AK6:AK94,MODE(MATCH(AK6:AK94,AK6:AK94,0))) I have this on the in cell 5 of each column. The number of values in each column may increase or decrease. If i reference the entire...

How to have two digits after comma in rails?

ruby-on-rails,model,calculated-field
I am trying to make calculation in my model, but i'm not able to get two digits after the comma. I tried different ways but when my result should be for example 7.50 or 7.25 I get 7 or 8. if you can tell me where the issue is, that...