Forum Discussion

PC2022's avatar
PC2022
Helper III
1 year ago
Solved

Sumx and if statement

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's avatar
    Jihwan_Kim
    1 year ago

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

     

2 Replies

  • Deku's avatar
    Deku
    Super User
    1 year ago

    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

    )

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    1 year ago

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