calculated

Hi Folks, Sorry if this is a double post but my last one seems to have disappeared Hope someone can help. I'm using the following if statement to populate a calculated value in sharepoint. It ensures the values defined are present before populating the email calculated field...

I have a calculated field with the following Expression: Round([RecNo],-2) The RecNo field is a regular autonumber field. I want the new calculated field to round the autonumber down to the nearest 100. E.g. <tbody> AutoNumber Calculated Field 78 0 150 100 399 300 1542 1500...

My statement is not returning any value unless I manually input values for the statement to evaluate. Font is set to general. I intentionally have my condition values to be equal to a cell. Below is my formulas that should work. I’m stuck and frustrated. I think it’s self explanatory, but...

Hello, I have a set of data with a primary ID and a calculated field (number). The primary ID can appear multiple times within the data set, with more than one calculated field values. I am looking for a formula to ask the data set, look through at each primary ID, and determine if at least...

I tried looking but can't seem the get the right keyword. Is there a way to create a calculated field for a pivot table where the columns are from a single field? To explain more clearly, I have a pivot table and on the "Columns" portion of the Pivot, there's a field called "STAGES". STAGES...

In a pivot table, can I insert a calculated field to evaluate a text entry? My calculated field is =IF(DESCRIPTION="C",AMOUNT*10) My result is always 0, regardless of whether or not the corresponding entry is a C or not. If I reverse it and make my field look for inequality, I get this...

I have a PivotTable with just two fields. I'd like to create a calculated field to manipulate that data. IF the DESCRIPTION field is "Contribution" I want to multiply by -1. IF the DESCRIPTION field is "Withdrawl" I want to multiply by -1. IF the DESCRIPTION field is anything else, I want to...

I have a pivot table with a column called category. Within category column there are 3 values: "Promoter", "Passive" and "detractor". I would like to create a calculated field which subtracts promoters from detractors. Can anyone assist? I will be much obliged.

I'm reconfiguring a workbook, where multiple sheets will each include a pivot table (PivotTable1), with the following structure, all sourced from the raw data sheet ("ALL DATA"): 1. report filter (each Unit's acronym) 2. 2 Row fields (GL account, and Trading Partner acronym) 3. 1 Column field...

I'm going to explain this as easy as I possibly can. Cell Z4 has a fuel amount. Let's say $2.50. If that amount falls within this range, then it will multiply by that percentage. So if somebody where to change the number in Z4, the result would update. The result is going in cell Z10. Now once...

Dear friends, I am new to Access. I am working to select records based on criteria using a calculated field. The criteria is the ratio of 2 fields is smaller than certain number. When I tried it using the imported SQL DB, it works. But when I use linked SQL DB, same DB and same calculated...

Hi, I have a source data which I can't change because if I add a column with a formula, it will make the file that much heavier. I'd like to calculate a simple ratio of calculations. Here's a simulated example of what I'd like. <tbody> Column A Column B AB Yes1 AB No EF - CD - AB...

I have a table that looks something like <tbody> Person Month Target Actual Variance % A Jan 1075 1500 28% B Jan 4109 4950 17% A Feb 1084 4000 73% B Feb 1000 2250 56% </tbody> The pivot table has a slicer that filters by person which works great when only looking at one at a time...

Hello, I have 4 columns named: "Blended" F30; "Construct" G30; "Intercept" H30; "Acquired" I30. Just below those columns (F31:I31), production totals for each column is calculated. I would like cell S21 to display the column name with the highest value below it.

Hi, I have a very large database in excel where I have created dynamic columns (I think they are called that); they are just columns with formulas referencing the data in the database. One formula looks like this: "=MAXIFS([OP];[Year];[@Year];[Client segment];[@[Client...

I want to rank numbers in a range that contains the following formula "=SUM(E2,F2,G2,H2)" using the RANK function "=Rank(I2,$I$2:$i$200)" but I want to skip cells that contain just the formula and no calculated value, until the calculated value is in the cell then that cell can be ranked. Can...

Please I am writing a spreadsheet and I have a range that contains formula (=SUM(E2F2G2H2) and I want to rank the final calculated values in the range using = Rank(I2,$I$2:$i$200), I want cells in the range with no calculated value yet to be blank cells in the column containing the ranks. Please...

Hi, Can anyone point me in the direction of an COVAR() tutorial/example that shows how the COVAR() function is calculated? I'm NOT looking for examples of how it's used, I'm looking for how it's CALCULATED using lower level functions i.e. SUM(), AVG(), COUNT(), multiplication and addition etc...

Hello all I am new to Microsoft Access and would like to ask a question I have a calculated field which looks at a field called "Total Cost" and divides this by 6 to get the correct VAT value I sometimes want to edit this field if the product has a reduced or no VAT charge Is there a way to...

Hi All, I inherited a power point presentation that shows the average, minimum and maximum values from survey response question. I have the underlying Excel data but don't have the work of the person that calculated these things. The average is shown, including the confidence level. I'm not a...