Sumx and if statement

Hi,

I am not sure about how the result will look like, but please check the below. In your formula, some of , , , ,  are missing.

EvalDesignComp30 =
SUMX (
    crb87_consultantevaluation,
    IF (
        crb87_consultantevaluation[Review Phase] = "30% Design",
        crb87_consultantevaluation[EvalPhaseDesign] * 0.15,
        IF (
            crb87_consultantevaluation[Review Phase] = "60% Design",
            crb87_consultantevaluation[EvalPhaseDesign] * 0.25,
            IF (
                crb87_consultantevaluation[Review Phase] = "100% Design",
                crb87_consultantevaluation[EvalPhaseDesign] * 0.6
            )
        )
    )
)