Formula to check whether the column has value or not

Deem_11

I have column that is named Category and it contains Accruals and Actual amounts, 

and I have applied some calculations based on this column 

I extract the data on a monthly basis, and some months may contain Accruals & Actuals or it may contain only Accruals with no Actual amount, this leads to an error that the calculation is missing an Actual number. 

Is there any formula that i can apply it to check if the column does not contain an Actual number then it will replace it with 0. 

cjaneczko

You can use the following.

if REGEX_Match([Field1], "\d+") then [Field1] else 0 endif