Current Month count of days

[viveksairam89]

Hi,

I want to establish the Monthly percentage

for example Today date is 22 june2017

22 days

current June month days is = 30 days

* 100 to calculate the percentage

Calculations:

22/30*100=73.33% it should be

[Anonymous]

Replace today() with your datefield

=day(today())/day(monthend(today()))*100

[viveksairam89]

Thanks for the quick response

If i want to get for Quarter wise monthly percentage ca you help me out

[henrikalmen]

Use a "master calendar" in your application to get quarter as a dimension to calculate by. Take a look for example at Creating A Master Calendar or at The Master Calendar.

[Anonymous]

You can use Quarter-functions to do this:

=(today()-QuarterStart(today()))
/
floor((QuarterEnd(today()))-QuarterStart(today()))
*100

!