How to calculate % of current month using Days cube
Hi Board Team,
I would like to calculate how many percent is passed for the current month. Basically, use today's date divides no.of.days in the current month.
For example, today is 9th Oct. I would like to achieve the calculation of 9 divides 31, which is 29%.
Can I use BOARD default time entity Day and Month to achieve this calculation?
Thanks
Accepted Answer
-
Harry,
It's okay on my side :
Which version of Board are you using ?
1
Answers
-
Hi Harry,
It looks like you’re on a quest to display the magic percentage of time passed this month ;)
Just pop this into your Algorithm Bloc and watch the magic unfold:
(DAY(TODAY()) / DAY(EOMONTH(TODAY(), 0))) * 100
Best regards,
Fethi Zerara1 -
Hi Fethi,
Thanks for your quick reply. I have tried this but no result in the table. It is blank.
I tried to break the Algorithm down. Today() is giving the correct answer. But day(today()) is not working. EOMONTH seems not working neither.
0 -
Cloud version 12.3 . We might upgrade to v14. Hope those EXCEL algorithm will work on v14.
Could you please let me know which version you are using?
Thank
0 -
Harry,
it should work in the 12.6
Best,
Fethi Zerara
0
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 161 Academy
- 328 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 194 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 5 Community Captains
- 1 About Community Captains
- 3 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 338 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP