Allow null values

[Former Member]

Morning All

I have created a list of values with dynamic cascading prompts.

But I am not able to show all the values at lower levels as I cant see the null values for the first two prompts.

Any ideas?

Anita

[Former Member · Accepted solution]

Hi Anita

Dynamic cascading prompts are used to filter data from database and it shows only the available values.

However we can show the null values by converting them to strings in Business view.

Try the below:

1.Create a formula field in the data foundation of the business view as below:

if IsNull then "Null" else

2.Create a business element for this formula field also, and

use this formula field while creating the Dynamic cascading prompt instead of the original database field.

hope this helps!!

Regards

Sourashree