Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Worked like a charm, thank you!