syntax set analysis

[#1]

Hi i have a calculation whereby i calculate accumulated value. This works well for current year 2013/2014

=Sum(

        {$<

            FYear={"$(=Dual(Max(fYear)-1 &'/'& Max(fYear), Max(fYear)))"},

            fMonth={"<=$(==Max( {<fYear={$(=Max(fYear))}>} fMonth))"}

        >}

        Nettobelopp)

i have tried to show previous year without any luck 2012/2013. i think my syntax is wrong, any ideas?

=Sum(

        {$<

            FYear={"$(=Dual(Max(fYear)-2 &'/'& Max(fYear) -1, Max(fYear)-1))"},

            fMonth={"<=$(==Max( {<fYear={$(=Max(fYear)-1)}>} fMonth))"}

        >}

        Nettobelopp)

Best

Brad

[MayilVahanan]

Hi

can you explain FYear contains data format?

can you provide any sample data / sample file?

[#3]

Thank you for your reply

i have attached the file.

the format of the FYear = 2013/2014;

[MayilVahanan · Accepted solution]

HI

Try like this

=Sum(

  {<

  FYear={"$(=Dual(Max(fYear)-2 &'/'& (Max(fYear)-1), Max(fYear)-2))"},

  fMonth={"<=$(=Max( {<fYear={$(=Max(fYear))}>} fMonth))"}

  >}

  Nettobelopp)

or

Try like this

=Sum(

  {$<

  fYear={$(=Max(fYear)-1)},

  fMonth={"<=$(=Max({<fYear={$(=Max(fYear))}>} fMonth))"},

  FYear=

  // månad,dag,datum

  >}

  Nettobelopp)