How to calculate % of current month using Days cube

Harry Sun · 2024-10-06T05:14:51+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Entity

Time range

Harry,

It's okay on my side :

Which version of Board are you using ?

Harry,

it should work in the 12.6

Best,

Fethi Zerara

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

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.

Harry,

It's okay on my side :

Which version of Board are you using ?

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

Harry,

it should work in the 12.6

Best,

Fethi Zerara