[Urgent]If no data/column, then create "0" into it

[AndyHH]

Hi Community!

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!

[AndyHH]

Hi  @danilang and thanks everyone

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!!!

[atcodedog05]

Hi @AndyHH 

Can you show me whats in this formula that's what might be creating the issue.

Hope this helps : )

[AndyHH]

oh thanks !! i did not notice there's one formula there, i removed it and works.

However, the situation now is if there's value then it will be "value" & "counts", which in this case i dont want the counts one.

I think i can only select the first one but just want to make sure that, the data which already existed will always in the row1?

If so, i will try to select only the first row to further calculate. Thank you!!

[atcodedog05 · Accepted solution]

Hi @AndyHH 

You missed out the filter tool from @danilang workflow please add it and it should work.

Hope this helps : )

[AndyHH]

Thanks everyone my question is solved!! This is really helpful !

[minhdvo]

Thanks for sharing the solution. It is perfect.