I want to establish the Monthly percentage
for example Today date is 22 june2017
current June month days is = 30 days
* 100 to calculate the percentage
22/30*100=73.33% it should be
Replace today() with your datefield
Thanks for the quick response
If i want to get for Quarter wise monthly percentage ca you help me out
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.
You can use Quarter-functions to do this:
Retrieving data ...