SUM Decimal Point


Im sure this is a simple thing but I can’t work out how, we are working out milage costs at the moment, so we have

SUM({July Miles}*0.45) at the moment, but its pumping up numbers upto 3 decimal places, how can I round this down to two so that I get £xx.xx as the end result!

Many Thanks in advance!

Hi Paul
Hope all is well
You just need to add a round to the formula
ROUND(SUM({July Miles}*0.45),1)
Changing the 1 at the end to 2 will be 2 decimal places(1 for 1 decimal place)
Screenshot 2022-10-14 at 09.43.42

Hope this provides what you need,
Please done hesitate to give me a shout if you need any further assistance
Many thanks in advance