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

[wale_martins]

Hi Sasidhar,

It continues being something wrong.... sorry

[vishsaggi]

may be try this?

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

AÑO={'$(=vYearSelect)'}>}

DISTINCT ID_VISITA))

[wale_martins]

It continues wrong... I don't know where the mistake it is...

[vishsaggi]

Try this

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

AÑO={'$(=$(vYearSelect))'}>}

DISTINCT ID_VISITA))

[wale_martins]

Neither..... Don't worry I will try to do it in another way......

Thank you for your time

[vishsaggi]

Hmm. Would you mind sharing your app where you have this expression used and your expected output?

[wale_martins]

Hi Vishwarath

There's some confidential data in it... Let me prepare a new document to attach.

Thank you very much!

[wale_martins]

Hi Vishwarath

Take a look to the attached file. I can't reproduce the exact situation... But what I want is that in my straight table '>40' appear all the customers... even those with no visits, but not the first 40.

Thank you in advance.

Wale

[vishsaggi]

Sorry could not check last night. will look into it and get back.

[wale_martins]

Don't worry! Just tell me if you find a solution for this issue!

Thanks!