Adobe Commerce to Looker Studio: SUM(grand_total) Is Not Revenue

The Adobe Commerce to Looker Studio guide on the MageSheet blog ends with a dashboard step: set grand_total to a currency and check that the aggregation is Sum. I ran the guide's Apps Script against a