-
2 editors for 1 etl in domo
Is it possible to have two people have the ability to edit an etl?
-
Simple Addition and Subtraction
Hi There, I am having trouble in returning correct values with a simple addition and subtraction beast mode. It appears that any column with a blank value will not return a end value. And any row with values in all columns calculates properly. Any suggestions on how to calculate to consider blank values as zero value?…
-
Division by Zero ETL error
Hello Can someone help me with this error... I am inputting a formula in Magic ETL and am receiving a division by zero error. How can I rectify it? I know in some cases the divisor in my calculation will be 0 but that is fine. An example of the 2 formulas I've tried below. Thanks for any insight. IFNULL(`Total…
-
Multiple Case When statement
Hi - I'm looking for a Case statement that will provide a new column when 2 columns meet a particular condition. I've tried multiple versions but none have worked. 2 examples below. Thanks in advance for any suggested fixes to the formula. IF(AND(`Plant`=1302,`Line of Business`='cable'),'QC Fibre','') WHEN(`Plant`=1302 AND…
