top of page

How to check for hard-coded values in formulas?

Hard-coded values in a formula are never a best practice as they are error prone when the user adjusts / changes the individual formula or the entire model / business case. The DQ Assistant identifies any formula that includes a hard-coded value

To help users identify hard-coded values in formulas, they can turn on the check by clicking Settings -> Formula -> "Hard-coded values in formula":

image.png

The DQ Assistant will then highlight all cells including formulas with hard-coded values:

image.png
bottom of page