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…