Dealing with null values inside table box/pivot table

[summerrain]

Hi Community,

I have a table box representing data:

ID	Status
1	-
2	Paid
3	Waiting
4	Canceled
5	-

What I want to achieve is to represent data in two table box(or couldbe pivot tables, it doesn't really matter), where one would be only with null(empty) values in the field Status and another without nulls:

ID	Status
1	-
5	-

ID	Status
2	Paid
3	Waiting
4	Canceled

Is that possible to achieve?

Thank you!

[tamilarasu · Accepted solution]

Have a look at the attachment.

[karthikoffi27se]

Hi

You can use the below syntax in the script and call it in expression using set analysis.

 NullAsValue*;

Set NullValue = '<NULL>';

Hope this helps

Many Thanks

Karthik