2 Replies Latest reply: Oct 9, 2013 10:40 AM by Fredrik Wikberg RSS

    Set Analysis with two functions

    Fredrik Wikberg

      Hi

       

      I have a Set Analysis where I want to only sum the values for the Max forecast submission. I have the expression below that doesnt work .

       

      =sum({<ForecastDate={'$(=date(Max(ForecastDate)))'}>} Volume)

       

      I dont know how to write the expression to get it to sum for only the Maximum forecast Submission which is stored as ForecastDate. I dont mind if I have to use a variable to get it to work. I have tried that as well but cant get the Set Analysis to work there either.

       

      I am happy for any help!

       

      //Fredrik