figure

I have this =CALCULATE([Sum of Amount], FILTER(DATA, LEFT(VALUES(DATA[Serial]),1)=5)) i am trying to check the condition. but it does not work. please help me figure out how to use the left function in DAX

I'd like to create a "roster" report from my database, listing every active record. It would be used as a "sign-in sheet", so I'm looking to create a report (pulling 3 fields - Last Name, First Name, Status) that look like the following: Ames, Jonathan (A) _____________ Hayes, Darren...

Hi everyone, I have a data set like the following. Unfortunately, my data is a lot more complex than this so a simple Pivot won't let me analyse it :( <tbody> Name/Year Apples? 2016 2017 2018 John Apples Apples Oranges Emma Apples Apples Apples Dave Oranges Apples Oranges </tbody>...

Hi I have a worksheet that I convert negatives to positives by selecting cell and then putting in formula -1* and dragging all the way down the worksheet. Im then trying to cut and paste the converted values into another row in the worksheet. If I copy and paste they change the red negative...

Hello Everyone, I have been working on a spreadsheet created by someone else, however I cannot figure below formula. Can anyone help explain it? Thank you. =XIRR(INDIRECT("R"&MATCH(B4,A:A,0)&":R"&MATCH(K4,A:A,0)),INDIRECT("A"&MATCH(B4,A:A,0)&":A"&MATCH(K4,A:A,0)))

Hello: I have figured out how to send a gmail or outlook email, adding spreadsheet ranges to the email body, and adding file attachments to the email using vba within excel. The one thing that I cannot figure out (and have searched extensively), is how to create a gmail draft and not send it...

I am trying to concatenate a complex string of text and percentages and variances and struggling to get it to work. Can any geniuses out there assist me? A1 = "Revenue" A2 = % which could be +/- which is referencing Cell B2, ie -5.3%. Negative figure not required to be pulled through A3 =...

Good morning: How do I convert S43422A to S43.422A. I cant figure out how to add decimal. Thank you!!

I'm hoping this is an easy fix. I need a formula that will average data in a column if a column contains x or y. Currently I have: N22 ={IFERROR(AVERAGE(IF((SEN={"n",""}),KS2A)),"")} However, this is returning 4.49 when it should be 4.83. It might be converting blanks to 0 hence the...

I am trying to solve an issue. =ifs(PasteMDMCoverage!E2="",Index(PasteMDMCoverage!F:F,match('Workforce Template'!E2,PasteMDMCoverage!B:B,false),01),if(PasteMDMCoverage!E2>0,Index(PasteMDMCoverage!E:E,match('Workforce Template'!E2,PasteMDMCoverage!B:B,false),01)) if there is no number in E...

I am using the formula =SUMIF(B2:NB2,">"&NC3,B4:NB4), row 2 is all consecutive dates, NC3 is today's date minus 1 year, and row 4 is accrued points that populate from a different page. I can't get anything to return except an error and I can't figure out why. Text, dates and numbers are...

Hi all, I have been searching the forums and google for an answer to my problem and I am having trouble on firstly what to search. I'm hoping you can either help me with a solution or get me on the right track for what to search. My question is how can I lookup a value (being a number...

I’m trying to combine 2 AND statements and can figure it out. By their selves both return TRUE... =AND($H2>=$C$2,$H2<=$D&2) =AND(K$1>=$B$3,K$1<=$B$3) Thanks for looking and for your help in advance. Charlie

Hi there! I would like to post a "thank you" but can't figure out how to do it. Many thanks, Jerry

So i have a macro that merges a file and makes it into a pdf. I have another macro I am trying to put into the first macro that deletes rows when they aren't filled. I cannot figure out how to put the macros together and get it to work. Ant advice is appreciated thank you!

Hello Everyone, First let me say that I genuinely want to learn how to use Access to build databases, I am just looking for guidance and have hit a brick wall trying to figure out my project. I have never built an Access Database and was wondering if someone would be willing to assist in...

Can someone please take a look at this formula and help me figure out what is wrong or maybe a better way to accomplish this? Thanks. =IF(AND(D13<$A$5, Recruitment_Package!$I$9={"In Bank Footprint"}), (D13*$B$5)/10000, (D13*$D$5)/10000, IF(AND(D13<$A$6, Recruitment_Package!$I$9={"In Bank...

Hi All, I have a list of performance percentage figures which I need to give a score of 0, 1 or 2 depending on whether they improve on a benchmark or not. If a figure is greater than the benchmark figure, a score of 2 is returned. If the figure is lower than the benchmark figure but within...

What code can i put into the two cells highlighted in yellow to sum up the WDRAW column by category? See attached image. I'M TRYING TO FIGURE OUT WHERE MY MONEY IS GOING!

I'm trying to use VBA to insert and fill down a Match formula from S7 to the last row in column S on ws1, and the range of the Match formula should be A3 to the last row in column A on ws2. Here's what I have, and it sort of works, except that the resulting formula has a #REF ! error. I'm...