How to change expression?

[#1]

Hi,

I have expression as below in Straight table. This will gives the number of students we got in that working week

Count(DISTINCT {<Post={'Enter'}>}StudentID)

I need to change the expression to get without NULL values. can anyone help me how to change this?

Thanks.

[#2]

Hey Amelia,

Nulls wont be counted. It will only count for Post = Enter

Thanks

AJ

[MK_QSL]

Count(DISTINCT {<Post={'Enter'}>}NOT ISNULL(StudentID))

[#4]

Attached a sample file to show that your expression wont count null values.

Thanks

AJ

[#5]

Thanks and If I want to create how many students entered each week means will the below  work?

Dimension 1=IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)

Dimension 2 = Organisation

Expression= Count(DISTINCT {<Post={'Enter'}>}StudentID)

[MK_QSL]

Dear Amelia,

If you post your sample file, it will be more helpful to work on.