Forum Discussion
Direct query resulting in infinity calculation
I'm using a direct query of a redshift data source and I'm having two issues. 1. A calculation is sometimes but not always calculating incorrectly and showing an output of infinity, you can see o...
Change the type of value in columns sum_ga_transactionrevenue and sum_cost from currency to number type. In addtion, check if the sum_clicks and sum_impressions are both number type.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.