earned

Hi there! I am trying to add the total points earned from a student. However, student ID column contains duplicate ID numbers. What I want to do is to create another column showing the student ID and the total points earned. Thank you StudId TOTAL POINTS 1619419 0.3 1619419 1 1619419 0.3...

Hi all, I am trying to do a planning schedule, which includes different earnings, such as; sick days, holiday earned, lieue days earned/taken, compensation earned/taken. The hoiday earned, and sick days were very simple because all I did was color code "H" for Holiday, and to the very right had...

Good morning all! I have a table with the following columns: Staff Name, Date IN, Hours Earned, Earned Comments, Current Total Earned. When staff are called in or work extra hours they are entered into the table so the Staff Name column will have staff listed multiple times. what I am trying...

Hi, I don't have experience with DAX and I'm trying to understand a DAX which is used in a workbook. Here is the link to workbook. https://community.tableau.com/servlet/JiveServlet/download/847360-289331/SampleData.xlsx This is the formula which is used to calculate earned exposure. =SUMX...

Suppose I have the following data <tbody> Alex 01/07/18 10000 Mike 09/07/18 20000 Alex 13/07/18 35000 Jason 13/11/18 26000 </tbody> Now, I'd like to find the maximum commission earned by a person for a month subject to the condition that for each transaction max commission earned...

I need a nested formula to pull a specific code type in a column. My transaction code field needs to pull AD, FY or RN = (Advances, First Year or Renewals). If the Earned/Advanced column has Advance, this automatically equals AD. If the Earned/Advanced column has Earned, this needs to be FY...

<tbody> rating 5-advanced 4- proficient 3- competent 2-developing 1- learning 0-nonperformer range 96-100 90-95 81-89 76-80 70-75 64-69 earned </tbody> Issue: I am trying to auto-populate a score in the "earned" row in the appropriate column based off a score in a...

Hi, I have set up a workbook to record flexi-time earned and taken. Any outstanding earned flexi-time can be carried over to the next month, but only for one month, so if you have a balance of, say, one hour that you earned in January, you can use it in February, but if it's still outstanding...

Say Bob Smith earned 13 raffle tickets Tim Harding earned 30, etc etc. Is there a formula that you can input that will create 13 versions of Bob Smiths name and 30 of Tim Hardings?

The table below is an example of what I am working on. I need help with column F. I can calculate a total balance using "Today()" in criteria: =SUMIF(C:C,">="&TODAY(),A:A) I can also easily calculate a running total in Column F without considering date expire to date used. In Cell F2 it would...