Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please share excel and explain the output
Hi,
May be like this (look attached file)
If(IsNull(FNDUSER_END_DATE)=-1, Count(FNDUSER_ID))
Result
Regards,
Andrey