I want null data to show a value.

[Paknanarn23]

This is Mode data with no date selected. But KCEPart1 and Layer are selected and all data is displayed.

But when I select date KCEPart1 and Layer the data shows Null.

What I want is when the date is selected to show the mode information of KCEPart1 and Layer of another day, but the information is still of the same Part and Layer. What should I do?

This is my Mode code. I tried it. But the data is still not displayed correctly. please help me

=if(len(trim(aggr(NODISTINCT(Mode(Minimum_line_width)),KcePart1,Layer)))= '-', aggr(DISTINCT(Mode(Minimum_line_width)),KcePart1,Layer),aggr(NODISTINCT(Mode(Minimum_line_width)),KcePart1,Layer))

thank you

[ajaykakkar93]

Hi,

Option 1: Use this
 If(IsNull(Sum(Value)), 0, Sum(Value))

Option 2: Sum(Value) + 0