• Resolved nayuk01

    (@nayuk01)


    Hi, I would like to know if it is possible to round a calculation to the nearest whole number and how I would do that?

    Thank you

    Naomi

Viewing 4 replies - 1 through 4 (of 4 total)
  • You can use the function round(calculation).

    Thread Starter nayuk01

    (@nayuk01)

    Thank you for your response @pawanahluwalia

    I am trying to use the round function but am not quite getting the right format. Please could you help me to correct this calculation that I am using.

    (%arena_length% * %arena_width%) * %sand_to_fiber_rate_04% / round(%divided_by_bale_weight%)

    It is performing the calculation correctly but not rounding the answer. Please could you show me how to use the “round” function correctly in this calculation?

    Thank you

    That is because you are only rounding the last number (i.e. the dividing number) not the whole calculation. If you want to round the final answer, then your calculation should be:

    round(%arena_length%*%arena_width%*%sand_to_fiber_rate_04%/%divided_by_bale_weight%)

    round([%arena_length%+%arena_width%+%sand_to_fiber_rate04%+%divided_by_bale_weight%] /3 ,2) In php that formula work , but when i use in static forms is show me in round number white out decimals? I am limited because whit out “round” show 15 decimals.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Round calculation total to nearest whole number’ is closed to new replies.