Loading

After Replacing Data Sources, Calculated Fields Disappear or Become Invalid

Julkaisupäivä: Apr 13, 2024
Kuvaus
When replacing the original data source, calculated fields may disappear from the data pane or are marked invalid (displayed with a red "!").

Cause

If calculated fields have disappearred: only calculated fields that are used are transferred to the new data source to help prevent clutter.

If calculated fields are marked as invalid: there are two reasons why a calculated field can become invalid.
  1. A field from the original data sources does not exist (including but not limited to changing the name of the field) in the new data source. 
  2. The new data source does not support all functions that are used in the original data source.
Ratkaisu

Scenario 1: Calculated Fields Disappear 

Try one of the following options
  1. After replacing the data source, copy and paste the calculated fields from the original data source to the new data source.
  2. Before replacing the data source, make sure all calculated fields are included in at least one worksheet.

Scenario 2: Calculated Fields Are Marked Invalid

Try one of the following options

  1. Replace Field References to the correct field. For additional information on replacing field references, see Replace Field References.
  2. Use a data source that supports all functions that are used in the calculation (extracting the data is an option).
  3. Check if the data fields using in the calculation field has the same dimension/measure setting with the original data source.
(for example a data field ABC is a dimension in data source A but a measure in data source B. If ABC is used in a calculation field XYZ, then replacing A with B will cause XYZ to become invalid.)

(Another example is when a field DEF is a Continuous field in data source A, but is a Discrete field in data source B. If DEF is used in a calculated field TUV, then replacing A with B will cause calculated field TUV to become invalid.)

Knowledge-artikkelin numero

001473543

 
Ladataan
Salesforce Help | Article