Sage 100

Is there a Help somewhere for the expression builder in BIE? Trying to create a field rounded to no decimals and the ROUND doesn't work like ROUND(expression,0).

Wonder if the pvx function PRC works....

Looks like BIE is using the BBx Round function - the attached file is a list of bbx to pvx functions From BBx Manual ROUND() Function - Round Number Syntax ROUND(expr{,int}{,ERR=lineref}) Description The ROUND() function rounds a number to a specified number of decimal places or to the current precision value. Parameter Description expr Number to be rounded. int Number of decimal places. If this parameter is not included, the number will be rounded according to the current precision level.

THANKS, @MoiraGoggin!

Does Sage make ANYTHING easy?????

Now wait, that looks like Round(expr,0) should have worked....

That's what I thought too when looking at the manual on this function, but it seems that you have to take into account the default decimal precision too. You didn't say @BethBowers what field you are running this calculation on, but if it was say a cost field and you have decimal precision set to 4, when you use the Round(field, int) and set int to zero that it may just override that. Could you provide an example of the field you are using the results?

I can't even get to the results - it gives me an error message which I assume is a syntax error just when I try to save the formula. I can save the expression without the ROUND function (It is Quanity * (-1) using the Transaction Qty field from IM Transactions), but as soon as I try to add the ROUND(,0) with my little expression in the middle, it chokes.

When I insert Round function in an expression it appears like this: {fn ROUND(table.column), n)} This is a dumb example but it appears to work w/o error: {fn ROUND(""SO_SalesOrderHeader"".""NonTaxableAmt"" * -1, 0)}

also here is the link for the documentation I found on bbx https://drive.google.com/file/d/0B1mFZ_a9XIuBMDU1MmNhYTktOWI5ZC00NDc5LWJlYjQtOTRlODhmMTYxZjBl/edit?hl=en&pli=1

Dumb things like this need to be dumbed down. The BIE ease of used is being marketed to the end user, not a rocket scientist computer programmer. If it is hard for us, just think of the poor joe user trying to make it work. They don't have the 90M tech support staff to back them up. This is why I still use Queries and Pivot tables. At least you get to use Excel functions........

AH, if I put the {fn} around it is DOES work, but not just as round(""IM_ItemTransactionHistory"".""ExtendedPrice""*-1,0) THANKS AGAIN! @MoiraGoggin

Yea, go 90Mers.....

Wait - thanks to @AlnoorCassim , too! I can't read today, apparently.