Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Amit,
Try this:
Count({<Date={">=$(=Num(YearStart(Max(Date))))<=$(=Max(Date))"}>} X)/Count({<Date={">=$(=Num(YearStart(Max(Date))))<=$(=Max(Date))"}>} Y)
Regards
KC
Over here Date is your date field in your application.
Regards
KC
KC you understood it wrong, need to calculate YTD average of the whole expression.
Thanks
AS
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)