9 Replies Latest reply: Feb 29, 2016 7:00 AM by Sunny Talwar RSS

    SET expression for compute the Balance sheet.

    Yeo Poh sai

      Hi All


      Some time back my below expression will compute the BS figure for me , out of sudden this expression refuse to work :-


      if([Exec P&L Level] = 's','',Sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}[Amount]*-1)/1000/$(ColumnDim98))


      In order to figure where go wrong , i need to know what are the above SET expression did ? Hope some one can share with me.