How to ignore 0 values

[Vinod]

Hi All,

In my straight table I want to display smallest 5 values but my denominator having some zero values,
How to remove/Ignore those zero values in expression.For your reference i have attached screenshot.

Thanks,
Vinod

[sunny_talwar]

What expression are you using for Denominator?

[Chanty4u]

you can use in denominator expression  include below code

{<Field-={0}>}

[Vinod]

Hi Sunny,

Please check my expression.

=SUM({<%KEY_DATE={">=$(=$(v_min_registration_date))<=$(=$(v_current_date_TARGET))"}>}[Monthly Target])

and I used [Monthly Target]-={0} within expression but it is not working.

Please suggest me other solution.

Thanks,

Vinod

[sunny_talwar]

Sorry, but I forgot to ask this earlier, but what is your expression for Numerator? Also, you want to show this chart with three expressions? Result1, N, & D? And which rows would you want to show in this chart?

[Vinod]

Hi Sunny,

Please check my expression.

=((sum({<History_Flag={'Y'}>}Overall)) + (count({<History_Flag={'N'},RF_Flag={'R'} >}VIN_NO)))
/ SUM({<%KEY_DATE={">=$(=$(v_min_registration_date))<=$(=$(v_current_date_TARGET))"}>}[Monthly Target])

Here Some of the Denominator Values are coming zero. How to exclude that all zero values and it should consider only non-zero.