Hi
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)
Hope this provides what you need,
Please done hesitate to give me a shout if you need any further assistance
Many thanks in advance
Dan