Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I written some count expression as mentioned below.
=Count({<EMPJOINDATE={"(>=$(vCalcDate)<=$(vToday))"},SECTION= {'*AB-*','*CD-*'}>} DISTINCT EMP_NUMBER)
Along with the above, i want to pass one more condition which is already filled in listbox. ListBox contains number of Sequence values (Days)
Example :
DAYS (ListBOX)
-----
1
2
3
4
5
6
7
8
9
...
...
100
When i select the listbox, then my count automatically should get change. I tried below expression. But, nothing will reflect.
what i want to do..?
Note : i created variable (vUserInput) ==> GetFieldSelections(DAYS)
=Count({<EMPJOINDATE={"(>=$(vCalcDate)<=$(vToday) + vUserInput)"},SECTION= {'*AB-*','*CD-*'}>} DISTINCT EMP_NUMBER)
will the syntax is correct...?
Inputbox is just to check variable values. Right-click in sheet-> add object->input box-> add variables to check