YTD average ????

[amit_saini]

Folks,

I'm having an expression named as % Due Eco = count(X)/count(Y) .  From this how can I calculate YTD average of % Due Eco for current year only???

Thanks,

AS

[jyothish8807]

Hi Amit,

Try this:

Count({<Date={">=$(=Num(YearStart(Max(Date))))<=$(=Max(Date))"}>} X)/Count({<Date={">=$(=Num(YearStart(Max(Date))))<=$(=Max(Date))"}>} Y)

Regards

KC

[jyothish8807]

Over here Date is your date field in your application.

Regards

KC

[amit_saini]

KC you understood it wrong, need to calculate YTD average of the whole expression.

Thanks
AS

[jyothish8807]

I guess you mean this:

% Due Eco=Count({<Date={">=$(=Num(YearStart(Max(Date))))<=$(=Max(Date))"}>} X)/Count({<Date={">=$(=Num(YearStart(Max(Date))))<=$(=Max(Date))"}>} Y)