Tableau formula Conversion to domo question

@kacy i'm assuming you've created a dataset with 'current day' and average 5 day usage' as columns.  you can do that, but I'm not sure I'd recommend this approach because you'll have tons of limited use datasets that only work for one visualization, and eventually it'll become a nightmare to maintain.

but setting that aside, Domo is built on SQL.  So you have to convert your query into proper SQL syntax.

looks like you had an extra asterix.  if that asterix is intentional, take it out of your dataset, it's unwise to use characters that are reserved for math in column names.

WHEN (`Average 5 Day Usage`) > 0 AND SUM(`Current Day Usage *`) > 0

also you have a problem with your parenthesis / your understanding of aggregation.  you can't have half of your formula operate on a SUM and the other half without.

(Sum(`Current Day Usage *`) - (`Average 5 Day Usage`))/(`Average 5 Day Usage`)

you can't do this.  Sum(`Current Day Usage *`) this is an aggregation, which means all other columns referred to in your dataset must be aggregated as well.

EITHER

Sum((`Current Day Usage *` - `Average 5 Day Usage`)/ `Average 5 Day Usage`)

OR

(Sum(`Current Day Usage *`) - SUM(`Average 5 Day Usage`))/ sum( `Average 5 Day Usage`)