Thank you Sherry, that is what I did -abhishek

I will check these and let you know the results, thank you

Oh and the time hierarchy does not come up when you are writing the formula. It is there in the subject area but does not show up when you are in the formula box

Hi Christian Thanks for the reply. I tried AGO("Assignment Event"."# Of Hires", "Time"."Month",1) and AGO("Assignment Event"."# Of Hires", "Time"."Time"."Month",1) and both of them did not work. The error message is a bit of a mix-up. Do you have the syntax that works? thanks Abhishek