Hi Guys,

I am trying to create a query that calculates the percentage of working days.

So for instance in feb 2023 there are 20 working days (Monday to Friday) given the current date is 23 feb we have already had 17 working days including today. 

What I want to show is that we are (17/20) * 100 = 85% through the month.

how do I achieve this in zoho analytics?

Kind Regards

Russell Powell