DDriderNew Contributor III7 months agoAdditional math on GetDataCell expressions I have a column performing the following expression: GetDataCell(Divide(CVC(CYAct)-CVC(PYAct)), CVC(PYAct))):Name(PY % Var) The column uses the following formatting: ExcelNumberFormat = 0.0%, Excel...Show More
KarlTContributor III to DDriderHave you tried setting the ExcelUseScale to false for that row/column to see if that solves it?
DDriderNew Contributor III to KarlT7 months agoIf set to false, it defaults to scale = 0 and doesn't change since scale is set to 0 in the column formatting..
Related ContentRounding function in GetDataCellGetDataCell CVR errorTransformation rules - Additional examples for the Range type expressionGrouping rows for GetDataCell rowsExclude members from rule expression
