This content has been marked as final. Show 4 replies
I want to store sum of the selected months YTD value into variable and take the avg.
if i select feb,mar,
ytd for feb is 100
Ytd for mar is 120
then i need to show the value(variable) is (100+120)/2(no.of selected months)=>220/2=110
the problem i am facing is i dont know how to take the YTD for the selected months.
I can take the YTD for the max month. using <=max(month) in set.
if they select more than one month then i dont know how to do.
could anyone help me.
thanks in advance.