Hi!! Knime Exoerts & Enthusiastic
I need your Help to solve following issue:
Situation:
COMBINER | Sum(Billed Quantity) | AVERAGE CB ACCRUAL RATE | AVG ACTUAL CB PAID | Rate Variation in Value | Rate Variation in percentage |
---|---|---|---|---|---|
10351-1143723 | 84 | 0 | 0 | 0 | 0 |
Requirement:
Case where Average CB Accrual Rate is “0” And Avg Actual CB paid is “0” then replace Rate variation in percentage to “-100”
I have wrote following code in column expression but it’s not providing expected output.
if (column(“AVERAGE CB ACCRUAL RATE”) == 0)
(column(“AVG ACTUAL CB PAID”) == 0)
(column(“Rate Variation in percentage”) == -100)
else
(column(“Rate Variation in percentage”))
PS: You can also guide me another node better than column expression.