Calculation condition in table box

[shaktisinghchau]

Greetings,

I have a table box where I want to show employees whose has status date in between start and end date variable, I checked all these 3 field has datatype of dates and format is MM/DD/YYYY.

I tried following expression but did not working, my table box is showing data beyond start/end date.

EmployeeStatusDate >= vStartDate and EmployeeStatusDate <= vEndDate

EmployeeStatusDate >= $(=vStartDate) and EmployeeStatusDate <= $(=vEndDate)

[omkarvamsi]

Hi Shakthi,

I have attached the application which can filter out dates between start date and enddate.

i did converted the dates to numbers in both variable and also dates from the field tooo.

i used set analysis and filtered the data.

check and confirm.

Regards

OM

[shaktisinghchau · Accepted solution]

Hello Everyone,

Calculation condition in table box or any other chart control will never filter internal data, this calculation condition accept true or false expression and if it true then only show data over table or chart.

To filter internal data of a field make it a dimension and write If expression on top of it, return null in case of false condition and check the "Suppress When Value is Null" check box like I am doing below.