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":

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

bottom of page