CONCAT(`bus_sector`.`site_code`, ' ', LEFT(`bus_sector`.`site_name`,15)) IIF([Time].CurrentMember.CHILDREN.COUNT=0,[Measures].[Subscriptors],([Measures].[Subscriptors],ClosingPeriod(Month,[Time].CurrentMember) ) ) Sum(PeriodsToDate([Time].[All Times], [Time].CurrentMember), [Measures].[Capex]) [Measures].[Min_moc] + [Measures].[Min_mtc] - [Measures].[Min_mtcTigo] [Measures].[Revenue] - [Measures].[Cost] [Measures].[Gross_Margin] - ([Measures].[Revenue]*.242) - ([Measures].[Revenue]*.083) [Measures].[Ebitda] - ([Measures].[Ebitda]*0.022) [Measures].[Cash_Flow]/[Measures].[Effective_minutes] [Measures].[AggCapex] Iif([Measures].[Payback] IS EMPTY,NULL,([Measures].[Target],Ancestor(RadioElement.CurrentMember,Region) ) ) IIf([Measures].[Cash_Flow] IS EMPTY,NULL,[Measures].[ValidCapex] / [Measures].[Cash_Flow]) [Measures].[AggCapex] Iif([Measures].[Cash_Flow] IS EMPTY,NULL,([Measures].[RUsers],Ancestor(RadioElement.CurrentMember,Region) ) ) Iif([Measures].[Cash_Flow] IS EMPTY,NULL,Iif([CoverageType].CurrentMember.CHILDREN.COUNT=0,([Measures].[VUsers],CoverageType.CurrentMember.Parent ),[Measures].[VUsers])) Iif([Measures].[Payback] IS EMPTY,NULL,([Measures].[Target],Ancestor(RadioElement.CurrentMember,Region) ) ) IIf([Measures].[Cash_Flow] IS EMPTY,NULL,[Measures].[ValidCapex] / [Measures].[Cash_Flow]) Iif([Measures].[ValidUsers] IS EMPTY, NULL, ([Measures].[Effective_minutes], Ancestor(RadioElement.CurrentMember,Region) )/([Measures].[ValidUsers])) Iif([Measures].[ValidUsers] IS EMPTY, NULL, [Measures].[ValidCapex]/[Measures].[ValidTarget]) Iif([Measures].[TargetCF]-[Measures].[Cash_Flow]>0,([Measures].[TargetCF]-[Measures].[Cash_Flow])/([Measures].[Mou]*[Measures].[CashPerMin]),0)