27 Replies Latest reply: Dec 27, 2016 9:22 AM by Vasiliy Beshentsev RSS

    Help with expression

    Vasiliy Beshentsev

      Good day, everyone!

      I have some throuble with expr. I need to get sum(Sales) over my filter.

      On first page i got total sum, it work correct:


      Sum({<t35PRDWAER = {'RUB'}>} DECNRPRDEC),

      where t35PRDWAER field is currency, DECNRPRDEC is sales

       

      On second page i want to get this, but it doesn't work:

       

      Sum({<t35PRDWAER = {'RUB'}, BVRPBEDVTZ <= (VTRBEGDVTR + year - (365/BVRZAHWVTR))>} DECNRPRDEC),

      where BVRPBEDVTZ is date of sale, VTRBEGDVTR is another date field, BVRZAHWVTR is something else.


      Please, help me write expression correct.


      UPD1: MY FALSE, FRIENDS, i forget to tell that i got 'YYYYMMDD' format in date fields!

      UPD2: HERE IS EXAMPLE.QVF, take a look, friends!