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

Multiple filters within set analysis

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

• Re: Multiple filters within set analysis

Try like this

sum(

{<

Pvm={'\$(=today(0))'},

Tilaustyyppi-={'70-Tarjous','80-Toimitus','10-Projekti',
'60-MyynLaina','72-Prospekti','74-RahTarj','HuolTarj',
'81-Varsiirto'}

>}

AvoinTilausmäärä*Hinta)

• Re: Multiple filters within set analysis

Worked like a charm, thank you!