How to skip the process if value is null

Question

Hey, I have to do a calculation from a value, lets take an example:

value2

Now I have to find the square of the number so the output will be:

valuesquare24

Now my problem is if the value is null I don't want the value to go formula tool (currently my canvas is throwing an error because the value column is empty).

value

Now it should not generate any output

Let me know if you have any questions.

Thanks,

Peace

philipmannering · Answer

If all your values are Null then you would end up with a new column that was all null.

If that's an issue your course of action could be to throw an error or remove the column. Both scenarios are  in the attached workflow. See if it solves your problem...

What if null.yxmd

Sshasnk · Answer

@Maskell_Rascal  What if all the value is null in value column? that was my question

thanks

Maskell_Rascal · Answer

Hey @Sshasnk

You could write an IF statement to prevent Nulls from being calculated.

IF IsNull([Value]) THEN Null() ELSE [Value]*[Value] ENDIF

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil