Counting the number of selected days as standard value.

[yucel_ozer]

Dear Friends,

I have month selected and the number of total days of April is 14  as used/filled days is 14 for  April.

I want to calculate measure (Y axis) / dimension (X axis)  by using the number of days,30 ( the number of days of April), not 14.

So, when I select 2 months or 1 year, the number of days should be added as a total number of selected days. (For example, when March and April selected, the result should be : 31+30 =61, And I need the value of "(Y axis) / (X axis)"

Could you please help me about the correct script on that.

I already used the master calender but the result remains same, the real number of days is14 for April.

Thanks and regards.

[Anonymous]

You're not getting any responses because it is not clear what you're doing and what the problem is.  It will be helpful if you can upload your application.
Meanwhile, just a guess (could be wrong) - look into the "Add-On" in chart properties, go to "Data Handling", and check the box "Include zero values" if it is not checked.

[yucel_ozer]

I will give you an example : :

By the way, I have already checked there is no data handling check box issue.

I am selecting a month, April as dimension, There are jonly total 14 dates in the database for April...

I want to calculate daily rate ( My Measure / the number of days). This means the number of days will be 30 for April (not 14)

When I choose more than a month, this total number will be added (For example if I select Apr and May, the number of days will be 30+31=61. This means, daily rate formula = My Measure / 61

I hope that explanation makes myself clear.

Thanks in advance.

[dwforest · Accepted solution]

Something like, if Date is your date field

MonthEnd(Max(Date)) - MonthStart(Min(Date))

[yucel_ozer]

I dont believe that the correct script could not be so basic.

I have tried to use several codes, set analysis, master calendar etc.

Thank you David.