Forum Discussion

ksab23's avatar
ksab23
Icon for Helper I rankHelper I
3 years ago

Cannot figure out the error in this formula with multiple IF conditions

Hi, long story short I need a formula for curriculum completion. I would like to have a calculated column, with status complete/incomplete or 1/0.

The logic for completion is as follows:
Part 1 - Mandatory courses: N12, N13, N14
Part 2 - Any 2 out of 6 courses need to be completed: N6,N7,N8,N9,N10,N11

 

Completion= IF(

        'User List'[N12] >= 1 &&
        'User List'[N13] >= 1 &&
        'User List'[N14]>=1 &&
        (
            IF(
            SUMX(
                VALUES('User List'),
                'User List'[N6] +
                'User List'[N7] +
                'User List'[N8] +
                'User List'[SN9] +
                'User List'[N10] +
                'User List'[SN11]
            ) >=2, 1, 0
        )
    ) >=1, 1,0)

Thanks for any suggestions!
Need Help

1 Reply

  • ppm1's avatar
    ppm1
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Not sure what additional analyses you have planned, but you should consider unpivoting your course columns and using a measure instead of a column.

     

    If not, please try this column expression.

    Completion =
IF (
    'User List'[N12] >= 1
        && 'User List'[N13] >= 1
        && 'User List'[N14] >= 1
        && ( 'User List'[N6] + 'User List'[N7] + 'User List'[N8] + 'User List'[SN9] + 'User List'[N10] + 'User List'[SN11] ) >= 2,
    1,
    0
)

     

    Pat