export const toNumber = (value?: string | number | null): number => { if (!value) return 0; if (typeof value === "number") return value; const stringWithoutCommas = value.replace(/\$|,|\s/g, ""); const absValueString = stringWithoutCommas.replace(/\(|\)/g, ""); if (isNaN(Number(absValueString))) return 0; return stringWithoutCommas.startsWith("(") && stringWithoutCommas.endsWith(")") ? 0 - Number(absValueString) : Number(stringWithoutCommas); };