Solved

Are "Over Ride Data Types" applied in order like a SQL case statement?

  • 1 August 2022
  • 1 reply
  • 21 views

Badge

Does anyone know whether or not the rules you put in the over ride data types area are applied sequentially like they would be in a SQL case statement (i.e. once a field evaluates to TRUE it ignores the subsequent logic)?

icon

Best answer by Christian Hauggaard 20 January 2023, 17:17

View original

1 reply

Userlevel 2
Badge +3

Hi Brandon 

Apologies for the late response. Yes, the rule at the top of the list of rules overrules subsequent rules. For example, if we transform the AverageRate field below from numeric to text, and then add a subsequent rule (further down the list) to convert it to a decimal, the result will be a text field. In other words the first rule to evaluate to TRUE (going down the list from top to bottom) will apply, and any rules further down the list that also evaluate to TRUE will be ignored. You can use the “Move Up” and “Move Down” buttons on the top right to rearrange the rules.

 

Reply