Stack Overflow
Stack Overflow

Questions tagged [calculated-columns]

A calculated column is calculated from an expression that can use other columns in the same table

A calculated column is calculated from an expression that can use other columns in the same table. The expression can be a noncomputed column name, constant, function, and any combination of these connected by one or more operators. The expression cannot be a subquery.

2235 questions
0
votes
1 answer

Excel manipulating columns

I want to build a formula in which it looks at a column in excel and if the column contains x as the value, it then finds the max of a different column. For example. = IF(F:F = "rate", Max(k:k)) but this columns up as a value error. Could someone…
dh1234
  • 11
0
votes
1 answer

SharePoint calculated column with 3 conditions

I have a SharePoint list like: SharePoint List "All Hours per Shift" are calculated from =IF([Time Out]="","0",TEXT([Time Out]-[Time In],"h")). Then breaks need to be deducted. My "Hours per Shift" are calculated from "All Hours per Shift" with…
Slawek
  • 13
  • 4
0
votes
0 answers

How to transform Measure to Colum in PBI

i need to make a division, One column over one mesaure, my measure is: VAR Selection = SELECTEDVALUE ( Manipulated[Business_Unit] ) VAR Selection_Month = SELECTEDVALUE ( Tasa[Month] ) RETURN IF ( NOT ( ISBLANK ( Selection ) ), LOOKUPVALUE…
Carlos Tellez
  • 147
  • 1
  • 2
  • 10
0
votes
1 answer

How to calculate value with multiple condition and how to design database?

I need to calculated data with multiple condition MinOTHrs MaxOTHs DayType Rate ------------------------------ ----------- 3 - Working_day 18 4 11 Weekend 18 11 …
WD_Apps
  • 23
  • 7
0
votes
1 answer

How to add numbers from different tables in PowerBi?

I am having a problem trying to find a sumif funtion for PowerBi. I have two tables a labor and a budget. My labor has the following columns: Section Amount invoice 1.a $10 1 1.b $11 1 1.c $12 1 1.a…
jordan23
  • 73
  • 1
  • 12
0
votes
1 answer

Calculated field in Sql Server 2008

create proc PrAspnet_RolesGet as select r.RoleId, r.RoleName, lr.RoleId as IsLoginetRole from aspnet_Roles r left join loginetRoles lr on r.RoleId = lr.RoleId The table loginetRoles contains one field - the RoleId. How can I replace the field…
Alexandre
  • 13,030
  • 35
  • 114
  • 173
0
votes
2 answers

SQL Computer Column Formula

A SQL Table (Trades) has three fields AvgProfit, MinProfit and Hold - Hold is a Computed Colum... If AvgProfit < MinProfit, Hold = 'Hold' and if AvgProfit > MinProfit, Hold = 'Trade' The Computed Col formula for Hold is as follows. SQL Table…
CraigJSte
  • 912
  • 6
  • 17
  • 33
0
votes
1 answer

How to create a third column called "Weight" based on value of other column? When the column value is NA, a 0 weight would be assigned

I have 4 columns in a data frame, and based on the 2 columns, the 5th column of weights needs to be created. When the column value is NA, a 0 weight would be assigned. Suppose I have this data frame in R called exp. from to tel post 1 S01 S02…
Abikian
  • 49
  • 6
0
votes
0 answers

How to add dynamically calculated field to resultset in MongoDB?

How to add dynamically calculated filed/column to the result-set documents? I don't need aggregation but if that's the only way with Mongo... yet I'm having troubles with $project aggregation stage. How to pass filed value(s) to a (non-aggregating)…
J. Doe
  • 1
  • 2
0
votes
0 answers

Convert vector values in Pandas rows into new rows in python

I have a Pandas Data frame that let say col3 has a list, I need to convert each item of the list into a new row as follow: I think I need to transpose on col1 and col2 but not sure. # the data frame that I have: pd.DataFrame({"col1" : [1,2,3], …
st1980
  • 1
  • 1
  • 2
0
votes
2 answers

How to calculate some field in one row using jquery

I have created some code to calculate some fields in row. But i added some function, so i can add row dynamically using jquery. This is my source code on my codepen Click here! this is my function to calculate qtyItem column and price…
Daniel Prasaja
  • 31
  • 5
0
votes
1 answer

How do I create a Boolean column in Power BI that identifies rows that have been voided or 'zeroed' in a transaction based data set?

I have a transactional dataset (Table). I want to identify rows that have the same ID and have amounts that are voided (or canceled). Basically what I want is a new column, "Voided", that looks something like: ID Amount Voided 1001 10 …
Emily S
  • 1
0
votes
1 answer

Use sum function in calculated column

Is it possible to use a sum function in a calculated column? If yes, I would like to create a calculated column, that calculates the sum of a column in the same table where the date is smaller than the date of this entry. is this possible? And last,…
Krahmi
  • 29
  • 10
0
votes
0 answers

By using like operator How to search text which is concatenated columns values

I am developing application with cakephp ,in my code i am developing search functionality.i have table with number fields . i want to search data which is concatenation of 3 columns values.but problem here it is in one column has id of value other…
Bala
  • 57
  • 2
  • 12
0
votes
1 answer

SQL Computed Column, CountIF 2 Tables

I have two tables tblData_VendorMasterSSPaymentTerms tblData_VendorMasterSSPaymentTermsCLM tblData_VendorMasterSSPaymentTerms contains a field labled VMSSPayTerms_AribaContractID which the values exist in table…
Shelton Thompson
  • 19
  • 3
1 2 3
…
99
100