AnsweredAssumed Answered

Round Number to 2 decimal places in calculation

Question asked by fmdataweb on Sep 18, 2018
Latest reply on Sep 19, 2018 by fmpdude

I need to create a calculation that will always return a number with 2 decimal places. I tried using the Round function but it doesn't always keep the 2 decimal places, e.g.


Round ( 120 ; 2 )


returns 120 not 120.00. I can do this easily when displaying the field on the layout but I need to get the value with the 2 decimal places in a calculation but can't find any native functions to do this. Any suggestions?