filter data based on input box

[#1]

Hi all,

i've a table like this (in script editor):

Branch, Date2, Sales, NoNew

    1, 03/06/2009, 300, 1

    1, 01/02/2010, 100, 2

    1, 02/02/2010, 120, 3

    2, 01/02/2010, 200, 4

    2, 02/02/2010, 150, 1

in layout i've an input box where i type a date. Based on this input i want restrict my data: dates >= input date

So i create an event trigger on variable, but i don't know how to create the condition in the expression. I'm only able to create this condition: dates = input date

[Anonymous]

Hi fiemazzo,

You can use the below mentioned expression to solve your issue

=sum(If (Date2 >= '$(vDate)', Sales))

I have attached sample application for your reference.

Br,

Narayanan

[ToniKautto]

I would use a Calendar object instead for the actual selection, to make the user experience a bit nicer.

[#4 · Accepted solution]

Thx Narayanan for your reply, your solution works fine but i found a way to solve the problem using this in my expression: ='>' & '$(var)'