Skip the rows according to the conditions

Question

Hello,
Is there any ways to skip the condition rows while doing SUM, but on count it should not skip the conditional row.

For Example.
Amount have 5 rows and it contains some Hexadecimal numbers.
I wanted to skip the Hexadecimal Numbers while performing the SUM,
But while count the Amount field, Should not skip the Hexadecimal number.

Amount51.671.72529029846191E 094

Output :
SUM : 17.6
Total Number of Rows : 5

Thank You in Advance.

maazumders · Answer

I've attached sample workflow and file for your reference. It get the desired answer. Please let me know your thoughts.

SampleWorkflow.yxmd

Book3Test.xlsx

Gawa · Answer

hi @Gaurav0001

You can create another column by Formula tool, and configure expression so value=0 when condition is met(Hexadecimal).

For that column, apply Summarize tool as usual.

This is an example of the above method. Please rephrase expression so as to fit your case.

bgreedy · Answer

For the example you gave I'd suggest doing each process separately then combing the results

* Filter out any Hex numbers and sum-up the total
* Count the total rows of all records
* Combine results with an append

Skip the rows according to the conditions.yxzp