Set E

[krishnacbe]

Hi

I new in implemneting Set Expression. Below is my set expression in a straight table.

count({<ExceptionsTeamIntervention={'-1'},Status={1},
Code={'no_suitable_appointment','contractor_not_found','appointment_not_found',
'manual_deployment_required'}>} if(IsNull(CompletionDate)=-1, LastUpdatedDate-ClaimDate

))

If I select Completiondate then the record is not displayed in Straight table. But should not display that record even if I am not selection CompletionDate.

Thanks in Advance.

Regards

Krishna S

[SunilChauhan]

use below code

count({<ExceptionsTeamIntervention=,Status={1},
Code={'no_suitable_appointment','contractor_not_found','appointment_not_found',
'manual_deployment_required'} ,CompletionDate-={}>}, LastUpdatedDate-ClaimDate

)

hope this helps

[#3]

Hi,

Based on what you've said, you need to display the record even if you are not selecting Completion Date. Am I correct?

Regards,

Janzen

[krishnacbe]

Hi Janzen

Yes, you are right.

Regards

Krishna S

[#5]

Hi,

May I ask what is the purpose of displaying a list box of Completion Date if it must not affect your straight table. If thats the case, you can use alternate state so that whenever you select a value in listbox, it will not affect the values in the straight table.

Regards,

Janzen