Hello,
for the first time I am working with SysComputedColumn and I am having a problem with this requirement. There is a view with SysComputedColumn, that returns some value with some number of decimal places. Iwant to take this value from system:
and round the value, that is returned by the SysComputedColumn to the same number of decimal places as is in the General rounding rule for EUR.
I have created SQL select statement, that returns the value of the General rounding rule (0.01). But I have no idea, how to round the SysComputedColumn returned value. I was thinking about something like:
return strFmt('ROUND(%1, mySelectStatement)',
SysComputedColumn::if(SysComputedColumn::and(projActualCostItemList),
SPLProjTransPostingCube::projReportingActualConsCostHours(),
SPLProjTransPostingCube::projActualConsumptionCostHours()
));
but I do not know, if it is possible to use the round function in SysComputedColumn or round function inside strFmt, because as I know, it creates SELECT statements from SysComputedColumns. I did not find any method for rounding the SysComputedColumn, just this thread: but it is not what I am looking for, as I need the number of decimals is not a constant, but it should be dynamic based on the value of General rounding rule.
Any idea, please? Sorry if I missed something, but this is first time I am working with SysComputedColumn, never have even heard about that before
