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
Gelöst! Gehe zu Lösung.
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
Hello fmvizcaino,
This solution helps with zeros. thank you,
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