SUPRESS NULL VALUES BUT SHOW ZERO VALUES

[wale_martins]

Hi there,

I've been fighting for a long, trying to supress "null values" in a rank expression when "supress Zero-values" option is unchecked, but there's no way...

Anybody have an idea...

That's my expression:

IF(RANK(TOTAL COUNT({<AÑO={$(=(vYearSelect))}>}DISTINCT ID_VISITA),4)>40,

    COUNT({<AÑO={$(=(vYearSelect))}>}DISTINCT ID_VISITA))

In the attached file, you can see that the first 40 values appear as null, but appear.... the thing is that I want don't want to show them but I want to show the last 5 values with the 0 result. So, that's why I have unchecked the "supress Zero-values" option.

Thank you in advance

Wale

[sasiparupudi1]

I am not sure if I got your requirement correct but have a look at the attached solution and see if it helps?

[wale_martins]

Thank you Sasidhar! It's not exactely what I want, but it can work!

[sasiparupudi1]

Please let me know if you need a different solution, we can try work it out.. Otherwise, please close this thread by marking any helpful and a correct answer

[sasiparupudi1 · Accepted solution]

Please try this expression again?

COUNT({<AÑO={$(=(vYearSelect))},

COD_EMPRESA={'=RANK(TOTAL COUNT({<AÑO={$(=(vYearSelect))}>} DISTINCT ID_VISITA),4)>40'},AÑO={$(=(vYearSelect))}>

}TOTAL <COD_EMPRESA> DISTINCT  ID_VISITA)

[wale_martins]

Yeah!!!! Working as desired!!! Thank you very much Sasidhar!