Question

How to handle null values in celonis.

Null values are coming as - in visualization and olap tables.

so how to hide them.

I have used isnull and coalsce () ,but it seems not working.

So any way to hide or change - for null values.

+12

Null value can be handled by using component filter and applying it to specific attribute.

Just use Filter statement in the OLAP table in the component filter and it should work as it will hide those - values.

For eg: you want to hide null value for certain set reason for rejection field.

FILTER "VBAP"."ABGRU"" IS NOT NULL;

So likewise in your case you can use table field combination to hide those null values.

Hope it helps.

Happy Learning!

Sign up