Can we do this without using Java?

[Ade Harrison]

Currently evaluating OpenRules/Drools and hit a bit of a problem.

I'm trying to round down a calculation without using Java. Fairly straightforward using Java's Math.Floor(.....) but is there a way just using OR? - really  important business rule maintenance has absolute minimal techy input

thanks in advance

[OpenRules Support]

If you really need to use the mathematical method such as floor(..) inside your business rules, it seems the use of Math.floor(...) is a quite reasonable solution. You also may hide your calculation formula inside you own Java methods tor in the Excl table of the type Method and call it from your decision table cell. 

[Ade Harrison]

thanks for that, think what I really wanted was confirmation that to do anything like this, you need Java.

I guess the best way would be to have a common xls of methods roundDown(), roundUp() etc.. and just include it

many thanks

[OpenRules Support]

OpenRules allows you to use Java expressions inside Excel's cells - similarly to the DMN expression language. Excel's own formulas are not supported in purpose - OpenRules uses Excel or Google Docs only as great table editing tools. This approach guarantees a very smooth integration with real-world IT systems.