Member: Installment Remaining Percent
CREATE MEMBER CURRENTCUBE.[Measures].[Installment Remaining Percent]
AS iif(
[Measures].[Installment Amount] > 0,
[Measures].[Installment Balance Amount] / [Measures].[Installment Amount],
null
),
FORMAT_STRING = "Percent",
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'Installment';