Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
count(distinct if( Date <= YearStartDate and Status = 3 and Area <> 'AP' and Area <> 'MH',EMPCODE))
here i have use year field in dimension.
Hi,
Here is the set expression.
Sum({<Date = {">=$(YearStartDate)"},Status = {"3"},Area -= {"AP","MH"}>}Distinct EMPCODE)
Regards,
Kaushik Solanki
Hi koushik,
Expression is correct but in my Date field blank date is present i want include blank date also
but due to your expression it remove blank date expression
so please tell how to add blank date .
Hi,
Why dont u give some dummy Date.
Regards,
Kaushik Solanki
Hi
The expression you gave in your original post will also remove lines with a blank date. But to include with a set expression like this:
Count({<Date = {">=$(YearStartDate)"}, Status = {"3"}, Area -= {"AP","MH"}> +
<Date -= {"*"}, Status = {"3"}, Area -= {"AP","MH"}>} Distinct EMPCODE)
The -= will display a syntax error in the script editor, but you can ignore that (its a script editor bug).
HTH
Jonathan
Hi,
Try this expression
Sum({<Date -= {"*"} + {">=$(YearStartDate)"},Status = {"3"},Area -= {"AP","MH"}>}Distinct EMPCODE)
Hope it helps you.
Regards,
Jagan.