3015223 - Error "The system could not calculate a value for unknown reasons" when showing totals for a calculated measure in SAP Analytics Cloud (SAC)

When selecting the option "Show Totals" in a chart that contains calculated measures and those calculated measures contain if/then statements that reference other objects in the model, you get a blank total and the error "The system could not calculate a value for unknown reasons" shows up in the formula bar.

Example:

Working:

IF(1=1,12, 14)

Non-Working
IF([d/"MyField":ABC]="01",12,14)

• SAP Analytics Cloud (Enterprise) 2021.21.11

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, formula, error, blank , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem