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

    SET expression for compute the Balance sheet.

    PAUL YEO

      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.

       

      Paul