FAQ Database Discussion Community


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...

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...

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...

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...

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...