658 questions
0
votes
2
answers
60
views
Can't manage to make multiple averages with SQL [duplicate]
I've been trying to see the average salary of each profession of a hospital (this is an exercise BTW) but I can't manage to make an average for each service separately.
My last and what I believe is ...
0
votes
1
answer
22
views
DAX How to Return Value Based on Business Logic
I have a data set that is pulled together from different sources, but on one table. I need a formula that will help me evaluate and choose the correct column.
3 Text Columns
USI
4Ever_Code
Kit_Code
...
0
votes
2
answers
42
views
Multiple conditions in Excel
I'm working on an Excel project and I need to assign scores to athletes based on their time and gender. I don't have a helper table, and I want to do this using a formula that takes both gender and ...
- 3
0
votes
1
answer
61
views
QUERY function with multiple conditions using time frame
I have this query that I am trying to add a condition to to filter out the results of a report given a time frame (time frame in my sheet is N2 and N3)
What I have now is the following and it works ...
- 87
0
votes
0
answers
89
views
Compare 5 columns with another sheet
I am trying to compare Sheet 1 row E to I and see if at any of these values matches the corresponding column C to G in sheet 2. Both sheets have the same header. If any of cells matches in sheet 2 on ...
- 21
1
vote
2
answers
189
views
Excel Sumproduct with multiple criteria lookup in two tables
For a report, I need to calculate the SUMPRODUCT() of amounts in a data table multiplied by a factor value determined using a lookup table, the factor value (and thus column) to use depends on ...
- 11
1
vote
1
answer
40
views
Calculate a score depending on multiple conditions in R
I'm dealing with a dataframe showing answers to a questionnaire by several participants. A certain question can have many correct answers and the data look like this:
a <- c(0, 0, 1, 0, 1)
b <- ...
0
votes
3
answers
70
views
If ... else : the condition has length > 1
I am trying to classify variants according to their type (polymorphisms, insertion or deletion). Here is a snippet of my input :
A T
G C
T AG
C T
TT C
AT CC
Here is the dput output, if you need ...
- 11
0
votes
1
answer
54
views
Multiple OR conditions in an AND formula
I'm trying to get a yes or no result from comparing certain items that could be the content of a cell (F2) with certain possibilities from (H2) and again from (K2).
If all the conditions are true then ...
0
votes
1
answer
57
views
Replicating IF ANY conditional logic or a SUMIF Equivalent in PeopleSoft Query
Setting up an expression with conditional logic to determine the type of requisition within our business logic. Some requisitions can have multiple REQ_LINE.LN_TYPE (e.g. Req Line 1 = CAT & Req ...
- 1
1
vote
3
answers
189
views
Case sensitive distinct count from one column based on cell values in another column in EXCEL
Can you please help me with finding the count of distinct (case sensitive) products sold (Column B) per store (Column C) as per below data? Product_sold column has data from B2: B10. Store column has ...
- 11
0
votes
0
answers
60
views
formatting a column based on its column header (Google Sheets)
I am trying to use conditional formatting on a range of data in Google Sheets. I want any given column's formatting to depend on its column heading, which is either a number between 1-5 or the word &...
0
votes
1
answer
102
views
Crystal Report If formula with multiple conditions
I'm getting an error message with this formula but can't see the wood for the trees of what's missing - please help!
if {vehinv_rec.master_class_2} = "RCV" and if {vehinv_rec.chassis_model} ...
0
votes
0
answers
41
views
Calculating emission values based on min or max of a certain column for specific reporting time
I am a SQL beginner and self learner working on improving my SQL fundamentals. I am trying to use retrieve the min and max Entry_ID to calculate emission values based on certain dates.
I have 2 tables ...
- 1
0
votes
1
answer
77
views
SAS Macro Proc SQL w/ Multiple Conditions
I'm trying to run a proc sql macro that contains multiple conditions strung together. Is there a way to correct the code below for the 2nd macro (rn_cnt) or is there a better approach? Background: ...
- 37