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