내 커뮤니티 업적 표시줄을 확대합니다.

Submissions are now open for the 2026 Adobe Experience Maker Awards.

Mark Solution

활동이 없어 이 대화는 잠겼습니다. 새 게시물을 작성해 주세요.

해결됨

rounding up to nearest (5) days

Avatar

Level 5

I have a field that shows the total # of actual days and I want to create a field that will take that # and round it up to the nearest 5 days.  

 

Example 1:  total actual working days = 18; total days = 20

Example 2:  total actual working days = 24; total days = 25

 

How can I do that?  Here is my file

1 채택된 해결책 개

Avatar

정확한 답변 작성자:
Community Advisor

@ReluctantProgrammer :

 

You can use below JS method to get it done.

 

Math.ceil(total actual working days / 5) * 5;

E.g:

Math.ceil(18 / 5) * 5;
20

Thanks,
Siva

원본 게시물의 솔루션 보기

2 답변 개

Avatar

정확한 답변 작성자:
Community Advisor

@ReluctantProgrammer :

 

You can use below JS method to get it done.

 

Math.ceil(total actual working days / 5) * 5;

E.g:

Math.ceil(18 / 5) * 5;
20

Thanks,
Siva

That's what I needed.  Thanks!!