3 Replies Latest reply: Jul 9, 2013 3:46 PM by Nirav Bhimani RSS

    Set Analysis last year calculation syntax

    Bradley Coyne

      Hi i have the following expression in my Qv Doc.

       

      =num(sum({$<FY = {$(=max(FY))}, Year=,Quarter=, YearMonth = {"<=$(=max(YearMonth))"},Month= >} Nettobelopp), '$#,##0;($#,##0)')

       

      i would like to find the values  - 1 year to measure against.

       

      my syntax however seems wrong,

       

      any help is greatly appreciated.

       

      =num(sum({$<FY = {$(=max(FY)-1)}, Year=,Quarter=, YearMonth = {"<=$(=max(YearMonth))"},Month= >} Nettobelopp), '$#,##0;($#,##0)')