Display Null Values

[Anonymous]

hi

I have Straight Table with 5 Dimensions and 1 Expressions.

In Expression i have 7 rows which are having values and rest of them are null values and i have to display only NULL values.

For example column name is sum(sales) Rows don't have sales appearing as "-" in table and rest of them have values.

I need to know how we can display only NULL values.

All dimension Suppress Null values are Uncheck.

Thanks

Manish Madan

[Gysbert_Wassenaar]

Maybe like this: Sum({$-<sales={'*'}>}sales). If not, then it would help if you can post an example document that demonstrates the problem.

[kji]

On the dimensions tab, make sure to check "Show All Values"

[Anonymous]

Hi ,

I Can't share the App.

I have a scenario where i have some set of employees and each employee is mapped with 5 KPI's  and each KPI is having a status codes like 0,'',1,2,3.

[EMP->KPI->CODE]

Now i have to separate out these Employees in two bucket like Employees having KPI status code in 1,2,3 then it should fall in one table and KPI with code 0 and '' in another table.

Bucket 0 and '' must have only those Employee whose all KPI mapped should be either '0' or '' .

please let me if any example required.

Suggest.

Thanks

Manish Madan