MEMBER [MEASURES].[MTD Act%LM] as (iif(

Written by Abdulsamad. Posted in Comments

MEMBER [MEASURES].[MTD Act%LM] as (iif([MEASURES].[ZeroValuePerUnit]=0 OR ISEMPTY([MEASURES].[ZeroValuePerUnit]),[Measures].[NullValuePerUnit], [Measures].[Internet Sales Amount]/[Measures].[ZeroValuePerUnit]), Format_String = '#.#0'