Set Analysis / Expression in a straight table to limit the dataset

[umashankarus]

Hi Experts

Like to understand about having set analysis / expression in a straight table to limit the data set selection

Attached the screenshots of the following

a) data

b) straight table with a calculated dimension (Count of a particular column)

c) Need details of expression / set analysis to limit the data selection containing data rows which have NULL values for column END DATE

Required Output is

3/11/1998  -- 1

11/6/1998  -- 2

[Anil_Babu_Samineni]

Please share excel and explain the output

[ahaahaaha]

Hi,

May be like this (look attached file)

If(IsNull(FNDUSER_END_DATE)=-1, Count(FNDUSER_ID))

Result

Regards,

Andrey