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

Harry,

it should work in the 12.6

Best,

Fethi Zerara

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