How to calculate % of current month using Days cube

Harry Sun

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

Fethi ZERARA

Harry,

It's okay on my side :

Which version of Board are you using ?

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

Harry Sun

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 Sun

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

Fethi ZERARA

Harry,

it should work in the 12.6

Best,

Fethi Zerara