Problem with a formula

[pgalvezt]

Hi,

I have the follow Formula:

sum({<Cuenta={'31010101'}>}Monto*-1) /Valor_Factor  (Works Fine)

But In the last row QlikView shows a negative value. I need to hide that row. Anybody knows how to do that.

Or I need to delete the row but I need to show all total.

Thanks!

[Anonymous]

= if ( sum({<Cuenta={'31010101'}>}Monto*-1) /Valor_Factor  < 0 , null() , sum({<Cuenta={'31010101'}>}Monto*-1) /Valor_Factor  )

And don't forget to suppress nulls.

[jerem1234]

Are you using dimension limits? I translated Otros using Google to Others. If you are using dimension limits, then go to dimension limits tab and un-check "Show Others" near the bottom.

[pgalvezt]

Thank you for your reply but is not what I want. I want to Hide the negative row but I need to show all total.

For example I have this

Sales

1

2

3

-1

------

5

I need to show the total 5 and hide the -1. If I put delete value nulls the total gives 6.

[Anonymous]

Hi

Is the attached what you are after ?

See reply from jerem1234 for explanation.

Best Regards,     Bill