How to calculate % of current month using Days cube

Harry Sun
Harry Sun Customer, Community Captain
25 Up Votes 10 Comments Name Dropper 5 Likes
in Platform

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

Tagged:

Accepted Answers

  • Fethi ZERARA
    Fethi ZERARA Active Partner, Community Captain
    Fifth Anniversary 100 Comments 5 Answers 25 Likes
    Answer ✓

    Harry,

    It's okay on my side :

    image.png

    Which version of Board are you using ?

  • Fethi ZERARA
    Fethi ZERARA Active Partner, Community Captain
    Fifth Anniversary 100 Comments 5 Answers 25 Likes
    Answer ✓

    Harry,

    it should work in the 12.6

    Best,

    Fethi Zerara

Answers

  • Fethi ZERARA
    Fethi ZERARA Active Partner, Community Captain
    Fifth Anniversary 100 Comments 5 Answers 25 Likes

    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 Zerara

  • Harry Sun
    Harry Sun Customer, Community Captain
    25 Up Votes 10 Comments Name Dropper 5 Likes

    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.

    image.png
  • Harry Sun
    Harry Sun Customer, Community Captain
    25 Up Votes 10 Comments Name Dropper 5 Likes

    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

Categories