1 Reply Latest reply on Jun 27, 2016 9:47 AM by steve.s

    Help. sumproduct(excel like) or window_range function with matching group ids to calculate result? Orchard example attached

    steve.s

      I am having a problem trying to create data within a table using a calculated field where I need some sort of sumproduct(excel like) function to sum their amounts based on their group id. I've included a packaged workbook using an orchard example of oranges, apples and peaches. I think the answer is some sort of window_range function with a matching ids. I've been trying for days with no success

       

      Please help!