Hi,
I have a expression which calculates the percentage value
=num(if(sum(if(match(Fileld1,value1' ) and match(field2,'value 2') ..... etc),1,0))>0,
sum(if(match(Field1,'value1' ) and match(field2,'value2') ....etc,1,0)))
/
sum(IF(match(field1,'value1' ) and match(field2,'value2') ...etc ,1,0))*100,'#,#00.00')
now i want this expression to return values such that when I select a month [DateField1]= 1st of selected month and [DateField2]= Maxdate of selected month.
Thanks in advance