Skip to Content
0
Former Member
Dec 07, 2006 at 06:34 PM

Formula varible need to calculate number of days within period

59 Views

Hi Guys,

I need to know if there a way to get number of days in period to do some calculation through formula variable. Say, a user select period 12/2006 in query and based on that the variable populate the number of days in that period "<b>30</b>" for that year, and bring that value <b>30</b> within the calculated keyfigure calculation.

for example.

20 + <b>30</b> (the number of days in period) = 50

Please let me know if there a way I can get this logic.

Regards,

Asad