Applying Rule based filter for calculated criteria

KNIME Analytics Platform
1

I have got sales data which has 3 columns

  1. Unit Price
  2. Quantity
  3. Sales Value

I need to apply rule based filter and extract all those records where in (Unit Price * Quantity) <> Sales Value

Is it possible ?

2

Hi,
I think the rule-based filter cannot do calculations like product. But you can add a math node and create a new column with UnitPrice * Quantity.
Afterwards you can apply the rule-based filter with
$Product$ < $Sales Value$ => TRUE

1 Like
3

Hi @wwwbhushan and wellcome.

Or I think you can try the Expression row filter with $[“Sales Value”] != $[“Unit Price”] * $[“Quantity”]

Br

1 Like