Hi. Use to belong to Experts-Exchange for years and now have re-subscribed.
I am trying to create a calculated measure in a cube for an average.
What I want it to do is first determine if the count of services is 0 then 0
else divide the total turn around days by the count of services. My turn around time
is based on certain statuses. I included a field in my status table to indicate if it is one of the statuses that the turn around time is calculated on.
WITH MEMBER [Measures].[AverageTurnAroundTime] AS
[Measures].[Turn Around Days]/[Measures].[SAR Services]
select [Measures].[AverageTurnAroundTime] on columns
from [SAR Management]
where [Sar Status Code].[Turn Around Time Indicator] = 1
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.