1 Reply Latest reply: May 19, 2011 3:16 AM by Kaushik Solanki RSS

    Help with formula

    Francis vd Grijn

      I have a formula which gives a year total from offertes.

      sum({<Boekjaar = {$(=max(Boekjaar) )}>}Offerte\Offertebedrag) +

       

      Now i want expand this formula with

       

      Status='Open'

       

      Can someone help me ?

       

      Sum ({<Boekjaar = {$(=max(Boekjaar)-1)}>}Offerte\Offertebedrag) +

       

      Sum ({<Boekjaar = {$(=max(Boekjaar)-2)}>}Offerte\Offertebedrag) +

        • Help with formula
          Kaushik Solanki

          Hi,

           

              

           

          Sum ({<Boekjaar = {$(=max(Boekjaar)-1)}, Status = {"Open"}>}Offerte\Offertebedrag) +

           

          Sum ({<Boekjaar = {$(=max(Boekjaar)-2)}, Status = {"Open"}>}Offerte\Offertebedrag) +

           

                      

           

          Hope this will help you, If not please describe u r problem in detail.

           

          Regards,

          Kaushik Solanki