No announcements
Found 933956 threads
-
1 VotesMDX DateDiff calculation error
Norma, thanks for the idea, but it throw an error: The operator ':' cannot be used with calculated members.Answered | 3 Replies | 3969 Views | Created by Alê Monteiro - Thursday, October 4, 2012 1:15 PM | Last reply by Alê Monteiro - Thursday, October 4, 2012 3:15 PM
-
0 Votes
Getting error in calculate function
I am getting few errors in calculated column.Answered | 2 Replies | 502 Views | Created by BrandNewindiaN - Friday, February 26, 2016 9:20 AM | Last reply by Balwant Patel - Friday, February 26, 2016 9:37 AM -
3 Votes
WSS 3.0 Calculated Columns (Always Errors, even simple example calculations)
check this calculated columns formulas referrence http://blog.raminassar.com/2011/11/13/examples-of-using-calculated-column-formulas/ Regards, ...Answered | 14 Replies | 46972 Views | Created by Goethals Frederik - Thursday, June 14, 2007 10:10 AM | Last reply by Rami M Nassar - Sunday, November 13, 2011 9:37 AM -
0 Votes
F9/Calculate causes a view of a different tab to appear until scroll down/scroll back up
On many pages of the workbook, with some consistency, when I press Pf9 or trigger a Macro that has Calculate in it the screen will present a partial view from another tab.Answered | 1 Replies | 459 Views | Created by glovett2012 - Sunday, August 23, 2015 12:25 PM | Last reply by Andreas Killer - Monday, August 24, 2015 7:12 AM -
1 Votes
Calculated members not checked?
The cube was already set to IgnoreNone, and when I add an invalid calculation, it returns an error.Answered | 3 Replies | 4339 Views | Created by Les R - Tuesday, October 27, 2009 2:10 AM | Last reply by Thomas Ivarsson - Thursday, October 29, 2009 6:21 AM -
0 Votes
Adjacent column calculation
Hi a.floranc, As you mentioned “Each couple of REEl and ESTIMATE hours is a child of a TASK”, this division calculation should be done within each TASK column ...Answered | 2 Replies | 468 Views | Created by a.floranc - Wednesday, May 11, 2016 5:36 AM | Last reply by Xi Jin - Thursday, May 12, 2016 7:50 AM -
0 Votes
Grand Total for Calculated Member
Hi SSASStarter, Calculated measures cannot be secured using Dimension Security in a straight forward manner, in fact they won't be listed at all in the Dimension ...Answered | 1 Replies | 1258 Views | Created by SSASStarter - Friday, October 25, 2013 5:46 PM | Last reply by Charlie Liao - Thursday, October 31, 2013 9:27 AM -
0 Votes
#Error in Calculated Column withinSharePOint but not in Designer
Hi Kansas, According to your description, you create a report in SQL Server Data Tool which works fine, the issue is that a calculated field display #error when ...Answered | 1 Replies | 723 Views | Created by KansasCoder - Monday, November 30, 2015 10:08 PM | Last reply by Charlie Liao - Wednesday, December 2, 2015 6:15 AM -
0 Votes
DFS replication tab error
DFS replication tab error.Answered | 2 Replies | 863 Views | Created by Aliah Murfy - Tuesday, May 12, 2015 10:42 AM | Last reply by MedicalS - Thursday, May 28, 2015 11:06 AM -
0 Votes
System Resources Used by Workbook with Several Tabs/Worksheets
Charles Excel MVP The Excel Calculation Site http://www.decisionmodels.com/Answered | 6 Replies | 3446 Views | Created by edv7028 - Friday, September 9, 2011 3:28 PM | Last reply by edv7028 - Saturday, September 10, 2011 2:18 PM -
0 Votes
BCWP calculation error MSP 2007
The formula with which the BCWP is getting calculated for Task level is not clear for me but I'm sure it does not depend on %Work complete or % Complete and depends ...Answered | 2 Replies | 6623 Views | Created by Dennis Kern - Tuesday, March 6, 2012 7:56 PM | Last reply by Agasthya.S.P - Wednesday, October 11, 2017 5:30 AM -
5 Votes
%Complete calculation
MSP seems to calculate correctly when I only mark progress through %complete.Answered | 8 Replies | 8132 Views | Created by Mimi Laongpanich - Tuesday, October 18, 2011 10:16 PM | Last reply by John - Project - Monday, October 24, 2011 3:12 PM -
1 Votes
adding calculated columns to powerquery
From Power Query tab select "From Table".Answered | 1 Replies | 19113 Views | Created by Gert VDV - Tuesday, February 24, 2015 10:09 AM | Last reply by Gil Raviv - Tuesday, February 24, 2015 10:44 AM -
0 Votes
Are calculated members "calculated" if they are not used?
There is no problem if we have many calculated members.Answered | 2 Replies | 1890 Views | Created by tank104 - Monday, November 26, 2012 12:50 PM | Last reply by Dhwani S - Wednesday, November 28, 2012 9:01 AM -
0 Votes
Calculating Ranks of Data
I have a spreadsheet that has three tas: First tab is raw data imported from a website. its about 10 columns and up to 300 rows. it has a mix of numbers in decimal form and ...Answered | 4 Replies | 1230 Views | Created by JHarding08 - Tuesday, August 7, 2018 4:45 PM | Last reply by JHarding08 - Friday, August 17, 2018 9:24 PM -
1 Votes
Many Calculated Columns
A few calculated fields using DAX formulas were used to enhance these pivot tables and pivot charts.Answered | 2 Replies | 1219 Views | Created by Nalani - Tuesday, October 22, 2013 7:42 PM | Last reply by John Lacher - Tuesday, October 29, 2013 10:36 AM -
3 Votes
MDX Calculation
Generally, when working with MDX, I try to get a query scoped calculation working first before migrating the calculation to the calculations tab of the ...Answered | 8 Replies | 3998 Views | Created by Dz0001 - Friday, March 16, 2012 2:32 PM | Last reply by Martin Mason - Tuesday, March 27, 2012 12:15 AM -
0 Votes
translation for calculated member
Hi, Yes you can set translation even for a calculated member.Answered | 2 Replies | 625 Views | Created by the_txeriff - Thursday, February 19, 2015 9:34 AM | Last reply by the_txeriff - Thursday, February 19, 2015 9:53 AM -
1 Votes
Average Rate calculation
That is not possible with simple query because for every single row you are looking at a calculation that has happened for the previous row and it is a summarization calculation.Answered | 8 Replies | 1018 Views | Created by Farook M - Thursday, April 6, 2017 11:05 AM | Last reply by Farook M - Friday, April 7, 2017 5:37 AM -
1 Votes
Restricting role access to calculated measures
I am not aware of a way to hide a calculated member.Answered | 4 Replies | 5461 Views | Created by timw2 - Tuesday, January 20, 2009 9:53 PM | Last reply by timw2 - Thursday, January 22, 2009 10:10 PM
No announcements
