Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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))
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))
hi
what do you want that the display will be
that it will display '-' instead of zero?
No display with some value are zero
And Merry Christmas.. It works !
Merry Christmas my friend