Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I did shared a test app with orginal if it did't help.
Please let me know i will provide a updated one.
Thanks
Hi,
Can you check the attachment, is that you are looking?