Help with visualization

[eduardo_dimperio]

Hi,

My code now (i hope so), is getting all data corretly, but its not show how i wish for.

First image is my code without SUM() and second image with it, but i dont want to show any line with zero and this zeros became from null values that came by the diferent measures per date.

Any ideas?

[sunny_talwar · Accepted solution]

May be use the following expressions:

If(Sum(CONSUMODIA0) > 0 and  Sum(CONSUMODIA1) > 0 and Sum(CONSUMODIA2) > 0, Sum(CONSUMODIA0))

If(Sum(CONSUMODIA0) > 0 and  Sum(CONSUMODIA1) > 0 and Sum(CONSUMODIA2) > 0, Sum(CONSUMODIA1))

If(Sum(CONSUMODIA0) > 0 and  Sum(CONSUMODIA1) > 0 and Sum(CONSUMODIA2) > 0, Sum(CONSUMODIA2))

[lironbaram]

hi

what do you want that the display will be

that it will display '-' instead of zero?

[eduardo_dimperio]

No display with some value are zero

[eduardo_dimperio]

And Merry Christmas.. It works !

[sunny_talwar]

Merry Christmas my friend