I have the ListBox to select or enter some number in user input box .
Based on the selection value from my ListBox or Input Box value, my count automatically should change automatically.
For Example,
if i select one number from my ListBox(ListBox Name : SeqDays) , then my count should get change automatically.
What i have done so for as mentioned below steps
1. I created one variable and assign those variable to "SeqDays" ListBox.
vUserInput =GetFieldSelections(SeqDays) ==> // ListBox values assigned to vUserInput variable
2. I have applied for one expression in a PIE CHART (i.e) ==> < 5 Days (Expression).
below is my expression.
=Count({<NewDate={">=$(vCalDate)<=$(vToday) + $(vUserInput)"}>} NewDate)
3. My other variables
vCalDate=date(vToday-5,'DD-MM-YYYY')
vToday=date(Today(),'DD-MM-YYYY')
My Requirement is,
I just want to add listbox value "vUserInput" into my date condition expression (>=$(vCalDate)<=$(vToday) )in to the condition.
I tried many ways. but, no way to track and get the userinput values. It is not working. count will not be changing based on my "SeqDays" selection.
What might be the problem.?????
pls. find attached sample file with condition i used...
Note : I tried to solve this issue for long time. but, not getting proper solution.
