How to create a sheet object display only records that meet certain logical condition?

[#1]

How to create a sheet object display only records that meet certain logical condition such as the Amount field is greater than zero and the description contains a certain string. Could you guide me how to do please?

[#2]

Hi Roberto,

You can try with separate IF statement before this IF.

I mean something like that: 

IF Crédito = 'Null' then

Crédito = 0 ;

Else

ENDIF;

Previous IF statement;

Or if you have access to database you can update in the database.

I think that's not change the values, just the information will be update. 

Regards,

Venelin

[#3 · Accepted solution]

Hi, basically I needed was displayed on a table only records that meet a certain condition, and what finally worked was to use a calculated dimension, as shown in the attached image.

Thank you all for your contributions.

[#4]

Congratulate you !

[#5]

Thank you!