hansva commented on issue #5042: URL: https://github.com/apache/hop/issues/5042#issuecomment-2733505402
It seems you only get null if there is never a matching rule. The moment one of your rules "matches" the rest of the rows will have 0.0 as a value. The main issue I think is that these are Excel-style formulas, but a "null" does not exist in Excel. The moment one of the cells has a type it will have a value (empty string) I added the formula to excel and have the same results:  -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
