Calculation Condition -Table Box

[#1]

Hi, I want to insert a calculation condition in a table box. I have a field with 3 possible expressions in it - " S, A & T". Which formula can I use to exclude all fields/rows which is blank/ doesn't have any of these three possibilities in them? Thanks   

[avinashelite]

Hi,

You cannot use calculated condition in the table Box. Use the calculated condition in the script.

try like

load *

from

where S<>'' and A<>'' and T<>''

[Anonymous · Accepted solution]

Hi,

Calculated column is not possible in table object. You may have a look on straight table with specific expression or we have option to omit row in table object. See below,

[ashfaq_haseeb]

Hi,

You cannot create calculate condition.

But you can do aggregation in backed and use aggregated field in front end.

Regards

ASHFAQ