This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I recently want to build a model which after combining two excels, if there's no data, i want to create "0" into the column, so that i can do calculation after this path. And most of the time it will have data so i can calculate directly, but if it didn't, I need to generate "0" on my own. Can anyone help for this?
I've tried the formula tool and type : if isempty([Sum_Amount]) then '0' Else [Sum_Amount] ENDIF. But it doesn't work.
How can i use other tool or how do i type it in the formula? Many thanks!
Thanks for your solution and I can generate the 0 now. However, my next step is, if there's value, i need to use my own value to ABS() to turn into positive. And if there's no value, i will want to use the generated '0' and also make it ABS().
Is there any path or formula to use? In my mind now is 1.See if value -> yes then ABS. 2. If no value -> '0' then ABS. And i will only need one figures for further usage. Many Thanks!!!