Ai often fails on such trivial tasks. I would use code in this case and any other case which requires math. You could try the same task with gpt-4o, it's likely it will produce better results, but you will need to take a cost into consideration