Sumx and if statement

[PC2022]

What is wrong with my formula please?

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))

[Jihwan_Kim · Accepted solution]

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
            )
        )
    )
)

[Deku]

EvalDesignComp30 =

SUMX(

crb87_consultantevaluation,

Var x =

Switch(

crb87_consultantevaluation[Review Phase],

"30% Design", 0.15,

"60% Design",  0.25,

"100% Design", 0.6

)

Return

crb87_consultantevaluation[EvalPhaseDesign] * x

)