How to round values in a fast formula
Hello, how are you?
I would like to round the values returned by this Fast Formula. Is there a function that does this? How can I do it?
IF l_manager_score <> 0 THEN
(
l_mdiv = l_manager_score / l_count_comp
l_manager_avg_score = TRUNC(l_mdiv, 2)
/******* Calculate the Average Rating Score 360 *******/
IF worker_count > 0 AND pair_count > 0 AND l_self_eval_stat = 'COMP' THEN
(
l_manager_avg_score = l_manager_avg_score * 0.60
l_worker_avg_score = l_worker_avg_score * 0.10
l_pair_avg_score = (l_pair_avg_score / pair_count) * 0.30
L_RETURN_VALUE = l_manager_avg_score + l_worker_avg_score + l_pair_avg_score
Tagged:
0