EazyBI shows zero values when it should not be shown

Hello ,

I have created EazyBI report by using table gadget.
In the specific report we could see some columns with the ‘0’ and some of the " Null " values.
Even though i chosen the option " Hide Empty" rows and columns.

Regards;
Thangavel.

Hi @Thangavel_VELUCHAMY

Predefined measure “open issues” is the difference between issues created and resolved in the all periods until the end of displayed periods.
If all issues that were created were also resolved in the displayed or previous time periods, it could return 0 value.

You could try using a Nonzero function when defining a new calculated measure (because you are not allowed to edit predefined eazyBI measures).
Try this formula.

Nonzero(
[Measures].[Open issues]
)

Martins / eazyBI support

1 Like