Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
yasminpriya
Gaurav Pal
Ram
christianasteves
 Post New Web Links

## More Related Resource Links

### calculated member grand total e subtotal problem

hi,

I have a cube where I added a  calculated member to extract the last non null value of a measure. This is the script

```Create Member CurrentCube.[Measures].[Trascinamento] as

iif(isempty([measures].[importo]),

([Data Rif].[Calendario].prevmember,[Measures].[Trascinamento]),

[measures].[importo]),

FORMAT_STRING = "Currency", VISIBLE = 1 ,

ASSOCIATED_MEASURE_GROUP = 'PUMA'; ```

when viewing the aggregate data in a hierarchy, calculated totals and subtotals are accurate only if all the children of a member are zero at a certain date, and if either has a value, the original total is not zero, and thus is also used in calculated member.

Es

hierarchy |          importo       | trascinamento

100-----10|     null                  |         10000
----20 |     null            &nb

### HELP: How to add Total to a row in a calculated column of a Matrix

Hey guys,

I guess the title wasnt the best representation of my problem, so basically what I need is to add a total of a row so I can count how many developments were closed under a certain SLA. So I created a matrix like the one below, let's say that the SLA for Bugs is 30 hours and for UserStories is 55 hours. What I need to work is the column "Leadtime On Track" to identify and quantify the volume of bugs and UserStories within these SLA, ok? So the matrix was built with the following structure:

- group by EntityType (bug ou userstory),
- group by EntityID (101010,101011,101012....n),
- Qty: [Count(EntityID)]
- Avg LeadTime: round(Avg(Fields!CycleTime.Value),2)
- LeadTime: =round(sum(Fields!CycleTime.Value), 2)

To identify the ones under the SLA I used the following formula, which worked:

=iif(((Fields!EntityType.Value.Equals("Bug")) andalso (sum(Fields!CycleTime.Value))<=30) or ((Fields!EntityType.Value.Equals("UserStory")) and (sum(Fields!CycleTime.Value))<=55), 1, 0)

however it only works on the dimension "EntityID", because where I tried to have the overall, dimension EntityType, by

### HELP: How to add Total to a row in a calculated column of a Matrix

Hey guys,

I guess the title wasnt the best representation of my problem, so basically what I need is to add a total of a row so I can count how many developments were closed under a certain SLA. So I created a matrix like the one below, let's say that the SLA for Bugs is 30 hours and for UserStories is 55 hours. What I need to work is the column "Leadtime On Track" to identify and quantify the volume of bugs and UserStories within these SLA, ok? So the matrix was built with the following structure:

- group by EntityType (bug ou userstory),
- group by EntityID (101010,101011,101012....n),
- Qty: [Count(EntityID)]
- Avg LeadTime: round(Avg(Fields!CycleTime.Value),2)
- LeadTime: =round(sum(Fields!CycleTime.Value), 2)

To identify the ones under the SLA I used the following formula, which worked:

=iif(((Fields!EntityType.Value.Equals("Bug")) andalso (sum(Fields!CycleTime.Value))<=30) or ((Fields!EntityType.Value.Equals("UserStory")) and (sum(Fields!CycleTime.Value))<=55), 1, 0)

however it only works on the dimension "EntityID", because where I tried to have the overall, dimension EntityType, by

### HELP: How to add Total to a row in a calculated column of a Matrix

Hey guys,

I guess the title wasnt the best representation of my problem, so basically what I need is to add a total of a row so I can count how many developments were closed under a certain SLA. So I created a matrix like the one below, let's say that the SLA for Bugs is 30 hours and for UserStories is 55 hours. What I need to work is the column "Leadtime On Track" to identify and quantify the volume of bugs and UserStories within these SLA, ok? So the matrix was built with the following structure:

- group by EntityType (bug ou userstory),
- group by EntityID (101010,101011,101012....n),
- Qty: [Count(EntityID)]
- Avg LeadTime: round(Avg(Fields!CycleTime.Value),2)
- LeadTime: =round(sum(Fields!CycleTime.Value), 2)

To identify the ones under the SLA I used the following formula, which worked:

=iif(((Fields!EntityType.Value.Equals("Bug")) andalso (sum(Fields!CycleTime.Value))<=30) or ((Fields!EntityType.Value.Equals("UserStory")) and (sum(Fields!CycleTime.Value))<=55), 1, 0)

however it only

### Show grand total running total in GridView Footer

In many scenarios we need to display Running total as well as Grand total in GridView footer. In this post i will try to explain in an easy way that how we can display running total & Grand total in a GridView footer combindly. To explain this solution using an example here i use a sales order report. The report contains all sales order amount in a tabular way. I will use a GridView to display sales order amount and use GridView footer to display Running total & Grand total. Let we have a customer table with id and name column plus an orders table with OrderID,CustomerID,OrderDate & Amount. Now our goal is to show all customers order with amount as well as page wise running total & grand total. Note that running total is necessary when you enable paging in a GridView where as Grand total is always you can consider.

### How to get character count in 'Multiple Text 'column using Calculated Column?

Hi All,

I have a multiple text box in a list

I want

• A column which lists number of characters in multiple list column example 188, 199 etc
• Multiple character column must not have more than 200 chars
Is this possible?

Appreciate all the help!

-saumil

### Trying to set Calendar Time Interval Using Calculated Column, but getting Error

ÃÂ

So i was trying to use a calculated column that added 7 days to the start date of a calendar item. The calculated column worked fine because i checked with several tests. Then i tried using the Column as the End Time in the Time Interval Setting in the Calendar View. This broke Sharepoint. Not the normal graceful error im using to seeing from Sharepoint but the Server Error Page when a dump happens in a ASP page. I havent enabled the full error page because i assume its not like i can fix it, i dont have the source code.

ÃÂ

Does anyone else experience this? If so is it a known problem and being worked on?

ÃÂ

Thanks!

### Font Expression in Calculated memebers?

I am using BIDS 2005 version 8.0.50727.42 The fontName and Fontsize properties of calculated memebers are not working ? Any one got the same issue?   Thanks, Alex

### overriding "grand totals" for calculated members

hi all, is there a workaround for overriding "grand totals" for calculated members?  (I cannot use the workaround whereby I create the calculation in the DSV or view directly due to it being a pretty complex Descendant parent/child calculation).   thanks much for any thoughts, Cos

### computed column specification - When is it calculated?

on insert , select...?  It's better than Trigger? thanks.

### In export, i want to disable column in excel sheet

Hello, I am doing Import/Export. While export i want to disable some column in excel sheet, so during upload or import same primary key I can use, instead of user modify such column. Regards, Sandeep

### Sharepoint: In Calculated Column, Code with multiple "IF" condition does not work.

Implemantation:ÃÂ ÃÂ CalculateÃÂ expected resolveÃÂ date exclude "Saturday" and "Sunday"ÃÂ ÃÂ based on Priority and Severity.Columns are:1. Priority:2. Severity:3. Raised on: Date record createdCode:ÃÂ Below is the code which contains multiple "If" conditions. For quick undersatnding, i separated major If condition. Below code does not work and sharepoint gives me Sytax error message. =IF(OR(Priority="Critical",Severity="Critical"),IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+3,[Raised on]+1), ÃÂ  ÃÂ  IF(OR(Priority="HIGH",Severity="HIGH"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+4, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+4,[Raised on]+2)) , ÃÂ  IF(OR(Priority="MEDIUM",Severity="MEDIUM"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+3),"dddd")="Saturday",[Raised on]+5,[Raised on]+3)) ) , ÃÂ  IF(OR(Priority="LOW",Severity="LOW"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+6, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+6, IF(TEXT

### Use Sharepoint Calendar Start Time field in calculated column

I'm trying to limit the calendar view to current week using the Sharepoint defined field Start Time. However, when I display the serial number behind the Start Time it looks like it is actually giving me the serial number for the Created Date field. I believe it is because the appointment is reoccurring but I'm hoping there is a way around it. I created a new testdate field and manually entered the date and set those appointments as all day events however they are not reocurring appointments. The testdate returns the correct serial number however the start time returns an incorrect serial number. SerialNumber1=DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time])) SerialNumber2=DATE(YEAR([testdate]),MONTH([testdate]),DAY([testdate])) Start Time  SerialNumber1 Testdate  SerialNumber2 8/31/2010 40420 8/31/2010 40421 8/31/2010* 40405    9/1/2010* 40405    9/2/2010* 40405    9/7/2010 40427 9/7/2010 40428 9/13/2010* 40405    9/14/2010 40434 9/14/2010 40435 9/14/2010* 40405    9/15/2010* 40405    *These are reoccurring appointments scheduled as all day events. The others were entered as one time appointments scheduled as all day events.

### Sorting a DVWP by Column Total

I have a survey list in Sharepoint 2007, which from what I understand means I can't add a calculated column. In this survey list I have some number columns that need to be calculated for display. They are: (1) Number of Weeks, (2) Number of Hours per Week, and (3) Number of Hours for Credit. In Sharepoint Designer, I've created a Data View Web Part which displays those columns and two additional "calculated columns." Scare quotes because the calculation is happening in the XSL of the web part, not an actual calculated column. These columns are (4) Number of Hours (Column1*Column2) and (5) Eligible Hours (Column1*Column2-Column3). I have the data view grouped by @Author (Created By) and a column total row for each group. I even figured out how to get column totals for all four columns though the nodeset is grouped by Author, which breaks out of the box. Great, beautiful. The final step is sorting the entire view by the column total of Column5. In other words, I want my groups of @Authors listed in descending order by their Total Eligible Hours. Is this possible?

### Excel 2003 pivot table - parent showing grand total than the sum of its children

All, In Excel 2003, I have a product hierarchy, for simplistic sake lets say it goes A > B > C > model nbr.  I have filtered on model nbr 1.  I have the product hierarchy in my pivot table and unit cnt as the measure. Starting at level A in the hierarchy I am showing a total unit of 12000, if I drill down to B it still shows 12000, if I drill down to C it shows 100 and if I drill down to model nbr it shows me model nbr 1 with a unit cnt of 100. So my question is why are my parents not filtering the model nbr, it is taking the total for ALL records that have level A as their parent regardless of the model nbr? This does NOT happen in Excel 2007 or when I browse my cube in SSAS.

### using [content type] in calculated column

I want to get the content type in the calculated column. [content type] is available in Moss not able to use that in 2010. Any idea?

### Problem when using calculated column as column group in a view

Hi, ÃÂ  I have a list withÃÂ a calculated column named 'FullName', the formula is: "FirstNameÃÂ & " "ÃÂ &ÃÂ ÃÂ LastName". I created a view group by 'FullName' column. The follow error appeared on the column: ÃÂ  &lt;!-- #RENDER FAILED --&gt; ÃÂ  Please help
 Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All