Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago

Display Sum in each Row

Hi good day, pls need assistance, can anyone correct my calculated column. I have Table 1 where i get the value and display the value in Table 2. they have common column under Category and both conn...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi AllanBerces ,

Please update the formula of calculated column as below and check if that is what you want.

REMAINING_HRS =
CALCULATE (
    [Sum of Remaining],
    FILTER (
        ALLEXCEPT (
            BRUNEI_WTI_PROGRESS_YRLY_sql,
            BRUNEI_WTI_PROGRESS_YRLY_sql[Task No./Phase]
        ),
        BRUNEI_WTI_PROGRESS_YRLY_sql[Task No./Phase]
            IN { "PRECPRA;NC000172", "PRECPRA;NC000135" }
                && BRUNEI_WTI_PROGRESS_YRLY_sql[Main Cat.] = "Q"
    )
)

Best Regards

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago

Hi Anonymous 

Im getting error when i try the calculated column from above.

Thank you in advance