Multiple filters within set analysis

[Anonymous]

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

[swuehl · Accepted solution]

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)

[Anonymous]

Worked like a charm, thank you!