Hi There!
I am trying to add to field totals together and then multiply by another.
It looks like this this:
(Jobs.Travel Time+
Jobs.Timeonsite*Jobs.MinuteRate) AS TotalEarned
This however gives a random figure.
If I remove for example the Travel Time it works perfect.
Please help!!
Thanks
Ben