2 Replies Latest reply: Jun 28, 2013 2:00 AM by Heino Juho RSS

    Multiple filters within set analysis

    Heino Juho

      Hi all,

       

      I am trying to set an additional filter to a straight table I already have, so that the table would only show orders created on the day it is viewed.

       

       

      The expression I already have is the following:

       

      sum({<Tilaustyyppi-={'70-Tarjous','80-Toimitus',
      '10-Projekti','60-MyynLaina','72-Prospekti','74-RahTarj',
      'HuolTarj','81-Varsiirto'}>} AvoinTilausmäärä*Hinta)
      

       

      It is in Finnish, Tilaustyyppi means order type, AvoinTilausmäärä means open orders and Hinta means price (if this helps). So it is basically open orders times price with certain order types ignored ('70-Tarjous' etc.). Pvm (means date) is the field I have for the order date to be used in filtering.

       

       

      Could I use something like

      sum(({<Pvm={$(=today(0))},
      {<Tilaustyyppi-={'70-Tarjous','80-Toimitus','10-Projekti',
      '60-MyynLaina','72-Prospekti','74-RahTarj','HuolTarj',
      '81-Varsiirto'}>} AvoinTilausmäärä*Hinta)
      

       

      to only show orders created on the day of viewing?

       

       

      Thanks,

       

      Juho