Is Magic ETL 2.0 able to handle more complex SQL injections?
Alright guys, I feel like I am going crazy. I have a beast mode card that works really well in calculating months on hand inventory. I am now trying to create an new ETL that does a group by vendor and I am trying to inject the same code. The issue is that 'Available Inventory' is always returning null for some reason. Is this a bug with Domo? Or is there an issue with my code?
when Sum(CASE when `Type`='Sales' then `Value` else 0 end) = 0 then 0
Sum(CASE when `Type`='Available Inventory' then `Value` else 0 end)
Sum(CASE when `Type`='Sales' then `Value` else 0 end)
The result I am getting is:
I have even tried simply filtering Type = 'Available Inventory' and nothing is returning. The odd part is that the only Type that is found is 'Sales'
Any advice would be great. Thanks!
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board