Remy looking for your kind help
I am just trying to make a table of a Remaining estimated hours by member user with except for one specific user.
I have rows Issue (sub-task hierarchy) and Assignee (select user hierarchy level members).
For Mesures dimension, I have a define field RAF(j) = [Measures].[Remaining estimated hours history]/8 and I want a different calcul for specific one user for example
RAF(j)=([Measures].[Original estimated hours]-[Measures].[Hours spent])/8
Could you help me please
You can use the CASE statement in your formula for the RAF(j) measure so that it would look something like this:
[Assignee].CurrentHierarchyMember.Name = "David Sand"
([Measures].[Original estimated hours]-[Measures].[Hours spent])/8
[Measures].[Remaining estimated hours history]/8
This will use the specific formula in cases when the Assignee’s name in the Rows section matches the name you set and the other formula for all other cases.
Let me know if this fits your use case!
Nauris / eazyBI support