4 Replies Latest reply: Mar 25, 2015 9:17 AM by Matt N RSS

    Find the Corresponding Date to Max Value

      I am attempting to find the week in which the max sales occurred. The date is needed to feed back into another formula to show the daily trend in the week.


      I have the max sales number but have hit a bump in trying to now return the ActivityWeek the amount is associated with.


      Max(AGGR(sum(ActSales), ActivityWeek))