SUM(SUM(BILLABLE_ORDERS) FIXED (add COUNTRY_NAME)) / SUM(SUM(ATTEMPTED_TXNS+VOUCHER_TXNS) FIXED (add COUNTRY_NAME))
BILLABLE_ORDERS
COUNTRY_NAME
ATTEMPTED_TXNS
VOUCHER_TXNS
It should be 0.82
Below is an extract of the data
Any reason why you're using FIXED (add field) ? If you would explain what you're trying to calculate in words that could help but if the idea is to do the total of the Billable Orders divided the total sum of Attempted__txns plus Voucher_txns and calculating this at whatever level your card is displaying using just:
field
SUM(`BILLABLE_ORDERS`)/SUM(COALESCE(`ATTEMPTED_TXNS`,0)+COALSECE(`VOUCHER_TXNS`,0))
In most cases, you will use FIXED when you want the calculation to be performed at a different level than the one used for the card (like you want to show global average next to the value for each country). Coalesce is just being added to ensure it either of the two values is null that we use 0 instead.
Your numerator appears to be totaling the billable orders by country. Over the total of attempted transactions and voucher transactions by country. The use of "FIXED" seems redundant. What happens if you simply to something like SUM(BILLABLE_ORDERS)/SUM(ATTEMPTED_TXNS + VOUCHER_TXNS)?
