Round rounds up if the next digit is 5 or higher. Otherwise, rounds down

Question

Can I use ROUND function instead of CEIL. I believe CEIL is causing the problem here. I do not know what parameter to use in ROUND function in this case.

Sale (Data Type-Double)FormulaSales OutPut (DataType -VWString)Output RequiredRounding UP or Down0.954545455ToString(CEIL(([Sale])*100)) + "%"96%95%If the 5 digit after decimal is < 5 then round down to the t number integer number. In this case it should be 95%0.986363636ToString(CEIL(([Sale])*100)) + "%"99%99%If the 5 digit after decimal is >= 5 then round up to the  number integer number. In this case it should be 99%

aatalai · Accepted Answer

@kal-tech take a look at thee workflow attached it is using the formula tool with the following expression

ToString(round([Field1]*100,1))+"%"

Let me know how you get on

Raj · Accepted Answer

@kal-tech 
ToString(Round([sales],0.01)*100) + "%"

this should work
basically ciel is to round upwards
floor is to round downwards

hope this helps.