My beast mode is not calculating correctly

Sbhatia

SUM(SUM(BILLABLE_ORDERS) FIXED (add COUNTRY_NAME)) / SUM(SUM(ATTEMPTED_TXNS+VOUCHER_TXNS) FIXED (add COUNTRY_NAME))

It should be 0.82

Below is an extract of the data

marcel_luthi

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:

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.

ArborRose

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)?

marcel_luthi

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:

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.

ArborRose

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)?