Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Replace today() with your datefield
=day(today())/day(monthend(today()))*100
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:
=(today()-QuarterStart(today()))
/
floor((QuarterEnd(today()))-QuarterStart(today()))
*100
!