Lines without values ​​are hidden

[Theo_Westseit]

Hello Guys,

I am currently struggling with the following frontend problem:

I created a new App with tables, but Lines without values ​​are hidden, although i activated the "Show zero values" (Chart Property / Add-Ons). So if i change the Selection the structure of tables varies, although it (the lines) should be fixed. 

What options are left to show 0 if there is no value?

Thanks!!

[MEDHA07]

In backend script itself create new filed with if conditional statements wherever it has null or blanks result should be zero .

if(isnull(field) or field=' ' or field='-' ,0,field) as Dervflag

field -Measure field

[Rohan]

Hi,

Try this in the Measure expression :

If(isnull(Measure), 0, Measure)

[Theo_Westseit]

Hello Guys, thanks for your answers. Do you think there is a possibility to implement the code into frontend? I've tried If(isnull(Measure), 0, Measure) at frontend but it didn't work...

[Rohan]

Hi,

Have you tried sum({1<set>}Measure) ?