11 Replies Latest reply: Feb 26, 2016 4:46 AM by Settu Periyasamy RSS

    Issue with getting result of set analysis

    surendra chunduri

      I am trying to return a result using set analysis which should return records only for one but instead it is returing all the results.

       

      Can some one please help with my query please.

       

      thanks

       

      =sum({$<[~Cmmdty_Commodity]={'Steel'},[Cmmdty_Period]={"=max([Cmmdty_Period])"},>}Cmmdty_Price)

       

      It should return result for the month of the june 2015 which is the maximum period we got and the data is passing from data island and i believe the selections will not impact the result of it. while is used only instead of sum i am not getting any data.

       

      Thanks in adva