Additional 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...
Forum Discussion
Looking at the GetDataCell expression, is this accurate? Looks like you have a misplace braket:
GetDataCell((Divide(CVC(CYAct)-CVC(PYAct), CVC(PYAct)))*100):Name(PY % Var)alternatively, you could try multiplying the numerator instead:
GetDataCell(Divide((CVC(CYAct)-CVC(PYAct))*100, CVC(PYAct))):Name(PY % Var)
Thank you, unfortunately either calculation still ignores the *100. May not be possible to apply multiplication to CVMath.