2 Replies Latest reply: Dec 14, 2016 3:51 PM by Sunny Talwar RSS

    Replace static number in Set Analysis

    bill yu

      I try to replace Year with max(year). However, the month is not showing anything except Month= {11}>}. And I need to add up 3-months value. Please advice.

       

      Here is what I have now (SUM ({$<Year={2016},Month={11}>}(Cash)))+(SUM ({$<Year={2016},Month={10}>}(Cash)))+(SUM ({$<Year={2016},Month={9}>}(Cash))). I want to change to a form of sum({$<Year = {$(=max(Year))}, Month= {$(=max(Month))}>} Cash)