Expression not working - Sum Total

[ashmitp869]

Hi all,

I am not getting the expression value : Please kindly assist :

dimension : PCTYPE with values Carer,Spiritual

if(PCTYPE='Carer',Sum({$<Phase_Start_Carer={0}>} Measure)/Sum(Total{$<Phase_Start_Family_Carer={0}>} Measure),
if(PCTYPE='Spiritual',Sum({$<Phase_Start_Spiritual={0}>} Measure)/Sum(Total{$<Phase_Start_Spiritual={0}>} Measure))

[kaushiknsolanki · Accepted solution]

Hi,

I see that you are missing the last parenthesis.

Try this.

if(PCTYPE='Carer',Sum({$<Phase_Start_Carer={0}>} Measure)/Sum(Total{$<Phase_Start_Family_Carer={0}>} Measure),
if(PCTYPE='Spiritual',Sum({$<Phase_Start_Spiritual={0}>} Measure)/Sum(Total{$<Phase_Start_Spiritual={0}>} Measure)))