You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to round values in a fast formula

edited Mar 24, 2025 10:52AM in Human Capital Management 1 comment

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!