IF (IsEmpty) Error

[koheny01]

Hello colleagues,

I am getting error when I run this formula.

here is the detail.

"Reportable_Total_Amount"   and   "Mismatch_Amount"   should be added to make the "Total". I have some empty cells in either fields. wherever there is one empty field, the Total remains empty and Total field will be blank.

I am trying to change the empty fields to show zero and let the addition add them up.

please see the pic below.

TOTAL= IF IsEmpty([Reportable_Total_Amount]) THEN ([Reportable_Total_Amount])='0'

ELSEIF
 IsEmpty([Mismatch_Amount]) THEN ([Mismatch_Amount])='0'

ELSE ([Mismatch_Amount])+([Reportable_Total_Amount])

ENDIF

[fmvizcaino · Accepted solution]

Hi @koheny01 ,

One thing you could do is to use a data cleansing tool to generate the 0. The you can create a simple formula only to add mismatch+reportable amount as workflow attached.

Let me know if this works for you.

Best,

Fernando Vizcaino

[koheny01]

Hello fmvizcaino,

This solution helps with zeros. thank you,

[fmvizcaino]

Hi @koheny01 ,

Great! Is there anything else you need in your solution?

Please mark the answer as correct if I achieve what you are looking for, if not, please let me know and I will try to help you further.

Best,

Fernando Vizcaino