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