Hi all,
I want to summarize the data of sub categories of work without 'bugfix'. It is one of sub categories of my work. Here I attached my screen shot. Then This is my coding to summarize the data.
if([WORK_EFFORT_PURPOSE_TYPE_ID (Custom)]='Change Request' or [WORK_EFFORT_PURPOSE_TYPE_ID (Custom)]='Support' or [WORK_EFFORT_PURPOSE_TYPE_ID (Custom)]='Retainer' ) then (total ([Business Namespace].[TimeEntry].[HOURS])) else (0).
My problem is where bugfix values are presented in the row that row value is not calculated. Please help me to calculate hours each rows.
Thank you.
Is this post a duplicate of this post: http://www.cognoise.com/index.php/topic,28218.msg90582.html#msg90582
Please read the forum etiquette and refrain from double posting.
This post does not specify what type of source you have but your other post indicates dimensional. Your expressions in both posts appear more relational. Which type of package do you have?
You may do better using the dimensional reporting style and dimensional functions when working with dimensional data. You should also provide more information about your package. Are there members for the different types of effort? Can you make a set of those members and then aggregate your measure using the "aggregate" dimensional function?
Here I'm using Relational package. Because I can't group work_effort_type in dimensional package that's why moved relational package. Then multiple column was generated each row using dimensional package. One more problem using dimensional package getting summarized Budget value so overall report went to wrong. Now My problem is Work_effort_purpose as a attribute of DB then It contain purpose of the work so I modified required group in to my action that is FEATURE, BUGFIX, RETAINER, SUPPORT. I need hours without bugfix hours. If data is presemt in bugfix i won't get result else get exact result. How to avoid it, to get exact results of all row?
Thank you Lynn.