Ciaran
07/22/2026, 10:33 AMAI Evy
07/22/2026, 10:33 AMAI Evy
07/22/2026, 10:33 AMAI Evy
07/22/2026, 10:33 AMAI Evy
07/22/2026, 10:33 AMCiaran
07/22/2026, 10:35 AMAI Evy
07/22/2026, 10:35 AMAI Evy
07/22/2026, 10:35 AMcombined_cost is in *cents (USD) * [(1) ]() .
If your SQL sum returns 10000, that equals $100.00 USD (10000 cents ÷ 100 = $100) . You would then convert that dollar amount to GBP using your preferred exchange rate.
So your workflow would be:
1. Sum combined_cost values (result in cents)
2. Divide by 100 to get USD
3. Convert USD to GBP using current exchange rateAI Evy
07/22/2026, 10:35 AMAI Evy
07/22/2026, 10:35 AM