Maximum across time
Hello, perhaps I'm stupid, but i can't figure out how to calculate a maximum for a period. I found an aggregation function x[MAX: y], but i couldn't figure out how to put time scale as a dimension in maximization function. The only thread I found on the forum was this: https://community.anaplan.com/forums/-/message_boards/message/717234?_19_redirect=https%3A%2F%2Fcommunity.anaplan.com%2Fforums%2F-%2Fmessage_boards%2Fsearch%3F_19_keywords%3Dmax%26_19_searchCategoryId%3D0%26_19_breadcrumbsCategoryId%3D0%26_19_redirect%3Dhttps%253A%252F%252Fcommunity.anaplan.com%252Fforums%253Fp_p_id%253D19%2526p_p_lifecycle%253D0%2526p_p_state%253Dnormal%2526p_p_mode%253Dview%2526p_p_col_id%253Dcolumn-1%2526p_p_col_pos%253D1%2526p_p_col_count%253D3 , but it's so clumsy and inefficient, that I would never imply it. Please help.
Best Answer
-
The TIMESUM function has MAX as one of the aggregate choices. Would that help?1
