Correct Total value in Matrix using Switch Formula
Hello All, I am needing help to correct my Total calculation in the below Switch formula, for now i set it to blank() New_Outstanding = VAR RoleName = SELECTEDVALUE(Loan_Contacts[ROLENAME]) RETURN SWITCH( TRUE(), RoleName = "Closer", [KPI_CDSent], RoleName = "Disclosure Tech", [KPI_DisclosuresSent], RoleName = "Funder", [KPI_FundedPackagesSent], RoleName = "Setup", [KPI_SubmittedToUW], RoleName = "Underwriter", [KPI_InitialCreditDecisions], BLANK() )
