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
-1
votes
1 answer
How to find the percentages per category per another category
I am having trouble trying to generate a calculated column in SQL
My query is
SELECT
p.PolicyNumber,
r.RiskType
r.RiskClass,
SUM(p.CommissionVAT + p.CommissionEXVAT) as Commission,
NULL as CommPerc
FROM policies p
INNER JOIN risks r ON p.id =…
H_13
- 3
- 2
-1
votes
1 answer
Calculate from database
I have a database with a table called: products.
In this table I have 5 rows:
ID as int
Product as varchar
Type as varchar
KG as int
Price_KG as int
Now I want to make a dashboard where I can see the total value of a type product.
For example:
Now…
-1
votes
3 answers
calculate form fields using jquery
i want a jquery source to calculate my form
-1
votes
1 answer
Power BI Report column format
I have 2 columns X and Y having comma separated values. I want to create a custom Column XY that will have data from both the strings in columns X and Y.
The below screenshot is the sample format in spreadsheet and need this to be achieved in the…
Harish Srikanthraj
- 11
- 1
-1
votes
1 answer
Looping through input values with jQuery and creating Total Sum
I have comments/reviews in my page. Every comments has hidden input fields that contains values. What I want to achieve is, to loop through this values (which have classes asigned), and then sum up the values.
арно нюм
- 165
- 14
-1
votes
1 answer
Why is Data Studio not aggregating the data?
I am trying to visualize in Data Studio the number of user sessions with a certain landing page. I cannot use a filter because I don't want to filter the whole table. To this end, I created a calculated field which assigns a value of 1 if the page…
j93
- 1
- 2
-1
votes
1 answer
Using a function in a calculated field in Powershell?
So I have this:
get-ADUser -SearchRoot 'boogers.com/Locations/Kleenex' |
Where-Object { $_.TITLE -ne 'Snot' } |
Select LastName,FirstName,Description,SamAccountName,Department,TITLE, @{Name='bs_value';Expression=@{Name='TITLE';…
leeand00
- 25,510
- 39
- 140
- 297
-1
votes
1 answer
calculated field with TKinter
i am using Tkinter. i would like to calculate to total price from price and quantity, but it don't work.
def adding(self):
if self.validation():
query = 'INSERT INTO products VALUES (?,?,?,?,?)'
parameters = (self.name.get(),…
yok
- 25
- 7
-1
votes
1 answer
Datediff on one Date Field. Issues with grouping by
I have a data set like: https://i.stack.imgur.com/pYiMr.png
I want to calculate the difference it takes to go from max of processing to min of received.
Here is the desired output table: https://i.stack.imgur.com/2juJH.png
Here is the Calculated…
Boston Common
- 1
- 2
-1
votes
1 answer
Values not calculating in Userform
Can someone please help me.
I have a userform which has a number of numeric fields. The issue is that my Total box will not calculate them as it is recognising a number as text. So for example if I was to say HE.Value (10) + ME.Value (10) for…
MBrann
- 223
- 5
- 23
-1
votes
1 answer
How to find the minimum value in tableau?
How to find the minimum value, and display one employee?
ID | employee | MIN
-----------+-----------+--------------------
IM32837253 | employee1 | 10.11.2016 20:48:40
| employee2 | 10.11.2016 20:10:40
I want to achieve that the…
Aleks21
- 95
- 1
- 2
- 8
-1
votes
1 answer
Select from two different tables and store calculated value in a newly created table (Microsoft SQL Server 2014)
What would be the best way to take values from two different tables like 1st table has the value of Price, where 2nd table has the value of Quantity, and I will multiply Price by Quantity and the calculated values, Total_Price which will be store in…
Lim Min Yi
- 148
- 15
-1
votes
1 answer
TSQL work out VAT
I have a query which give me the Gross Amount for a Repair-
That amount is 10.88.
I also pull back the VAT rate that corresponds to the Repair.
In this instance it is 20.00. (20%) But this could in theory be any rate, for example 17.50.
These two…
ikilledbill
- 211
- 1
- 3
- 17
-1
votes
3 answers
How can I construct a Stored Procedure that will return a result set containing many calculated values?
These are the values that I need to return from a stored procedure:
Description
Week 1 Usage
Week 2 Usage
Usage Variance
Week 1 Price
Week 2 Price
Price Variance
% of Price Variance
The three fields with "Variance" in their name are calculated…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
-1
votes
1 answer
How to create calculated column with data from same list
I have a list where user can request amount of 1000 either one time or two time, if user request a amount, sharepoint automatically check with previous amount and subtract from 1000.
suppose: A request 500 one time, next time if i create a list it…
Riz
- 1
- 2